Interested to Buy Any Domain ? << Click Here >> for more details...
<?php
include ("db.php");
$result = mysql_query("SELECT ques_id FROM questionbank
order by ques_id limit 5 ");
while($obj=mysql_fetch_array($result))
{
$ad1[$obj['ques_id']]++;//Used an array and inserted the
database query results into it.
}
$rand_keys=array_rand($ad1,1); //Did a random array function
echo "First random id = ".$ad1[$rand_keys[0]];
echo "<br>Second random id = ".$ad1[$rand_keys[1]];
?>
<!--Its not working. Have any solution for this. -->
- 1 Answers
- 4784 Views
- I also Faced
- E-Mail Answers
Answer Posted / bibhu
The following is your program. you need some little bit
change on this program.
<?php
include ("db.php");
$result = mysql_query("SELECT ques_id FROM questionbank
order by ques_id limit 5 ");
while($obj=mysql_fetch_array($result))
{
$ad1[$obj['ques_id']]++;//
}
$rand_keys=array_rand($ad1,1); //Did a random array function
echo "First random id = ".$ad1[$rand_keys[0]];
echo "<br>Second random id = ".$ad1[$rand_keys[1]];
?>
Your Mistake
1. in while statement you add $ad1[$obj['ques_id']]++; which
is not assignment statement. It is a increment statement.
The correct answer is $ad1[$obj['ques_id']] = $obj['ques_id'];
2.in array random function You use 1 key but you display random
array value using 2 keys.
$rand_keys=array_rand($ad1,1); //Did a random array function
echo "First random id = ".$ad1[$rand_keys[0]];
echo "<br>Second random id = ".$ad1[$rand_keys[1]];
just change 1 to 2 in array_rand($ad1,2);
The Changes are from while statement.
while($obj=mysql_fetch_array($select))
{
$ad1[$obj['ques_id']] = $obj['ques_id'];
}
$rand_keys=array_rand($ad1,2); //Did a random array function
echo "First random id = ".$ad1[$rand_keys[0]];
echo "<br>Second random id = ".$ad1[$rand_keys[1]];
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to create a text file in PHP?
How many keywords are there in php?
What is the meaning of symbol '$' in jquery?
Is polymorphism inherited?
What does php do?
How can I display text with a php script?
How do I stop a php script?
What is the use of magic function in php?
What is php regular expression?
How does one prevent the following warning ‘warning: cannot modify header information – headers already sent' and why does it occur in the first place?
What is a class in php programing?
How many different types of messages available in php?
Which php framework is best for web development?
How to strip whitespace (or other characters) from the beginning and end of a string?
What is mean by an associative array?
