How to get the data from mysql in random

apcmlee

Dear all,

In mysql, I would like to select one row of date from the table "TEST" in random. Please give me some help, thanks

Regards,
Simon

bpat1434

Just create your query, and use a random variable number created by php.

<?php
$rand = rand(1, 5);

$query = "SELECT * FROM `TABLES` WHERE id = '".$rand."' LIMIT 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
?>

int rand ( [int min, int max] )
Example 1. rand() example
<?php
echo rand() . "\n";
echo rand() . "\n";

echo rand(5, 15);
?> 
The above example will output something similar to:

7771
22264
11

PHP Manual - rand()

Hope that helps.

~Brett

apcmlee

If two rows of data are taken instead of one row, how does it do?

Thanks
Simon

bpat1434

You would have to execute the query twice, calling a function to get another random number.

~Brett

bretticus

SELECT * FROM table ORDER BY RAND() LIMIT 1

apcmlee

Dears,

I try it, but such query is not good, since the id's may not be continuous, resulting in no data some time. So please help me with any other solutions. Also if I want the random no be the same for a whole day, how does it do?

Thanks for any of your help.

Simon

bretticus

If you want a random record for the day, choose the record in the same manner and then store the id in a record or file.

Your script could check for the existance of the stored id and whether it's time to get a new random id to store (you could put the id in a record that is timestamped for example.)

goaman

apcmlee wrote:
Dears,

I try it, but such query is not good, since the id's may not be continuous, resulting in no data some time. So please help me with any other solutions. Also if I want the random no be the same for a whole day, how does it do?

Thanks for any of your help.

Simon

Hi,
I think this what ur trying to do, try this out.. 🙂


<?php
$limited = 10;
$rand = rand(1, $limited);

$query = "SELECT * FROM `TABLES` LIMIT ".$rand.", " . $limited;
$result = mysql_query($query);
$row = mysql_fetch_array($result);
?>