<?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. -->
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
Why do we use query?
Explain some of the php string functions?
How can we extract string "pcds.co.in" from a string "https://info@pcds.co.in" using regular expression of php? More on reg can you explain
What is difference between array_merge and array_combine?
What is difference between include and include_once in php?
What is artisan in php?
What is the difference between explode() and split() functions?
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 language is similar to php?
What is the difference between abstract class and interface in php?
How to declare an array in php?
Inside a php function, what param needs to be set in order to access a global variable?
How is php different from other languages?
What is list in PHP?
Is php the same as html?