<?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
- 4409 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
What is the difference between php and cakephp?
How can I load data from a text file into a table?
Why did you choose this particular career path?
Why many companies are switching their current business language to php?
Is php faster than javascript?
Which functions are used to remove whitespaces from the string?
What is empty php?
What is the meaning of xdebug?
Explain what is the difference between for and foreach?
Is php class name case sensitive?
Explain what does the unlink() function means?
What is the difference between $argv and $argc? Give example?
What is array and function?
When do you use define() and when do you use const. What are the main differences between those two?
What are regular expressions in programming?
