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
- 4760 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What’s the difference between htmlentities() and htmlspecialchars()?
What are escaping characters? Explain with an example?
What is a PHP Filter?
How to find the position of the first occurrence of a substring in a string?
What is the php function that removes the first element of the array and returns it?
When do you use define() and when do you use const. What are the main differences between those two?
Tell me what is the difference between characters 34 and x34?
What is difference between str_replace and substr_replace
How to remove white spaces from the beginning and/or the end of a string in php?
What is php ci?
Write a program in php to print a table of a number?
Which function is used in php to count the total number of rows returned by any query?
PHP 
