Random Number Function?

[Solarpitch]

Hey Guys,

 

Just wondering how I can achieve this. I want to query a database table and return the min and max id of the table. so if there's 3020 records it will return..

 

min = 1

max = 3020

 

I then need to generate a random number between these two values.

[kbfirebreather]

$selectHigh = "SELECT * FROM table ORDER BY id DESC";
$selectLow = "SELECT * FROM table ORDER BY id ASC";
$queryHigh = mysql_query($selectHigh) or die(mysql_error());
$queryLow= mysql_query($selectLow ) or die(mysql_error());
$high = msyql_fetch_assoc($queryHigh);
$low= msyql_fetch_assoc($queryLow);

srand ((double) microtime( )*1000000);
$random_number = rand($low['id'],$high['id']);
echo "$random_number";

 

something like that

[Psycho]

Or just do one query

 

$query = "SELECT MIN(id) as min, MAX(id) as max FROM table";
$result = mysql_query($query);
$record = mysql_fetch_assoc($result);
$random_number = rand($record['min'], $record['max']);

 

Note, as of v4.2.0 srand() is not necessary