random record help

[Anon]

04/12/2000

Hi

Can anyone help with the following.

I am trying to run a query where i want it to pickup a random number from a list of topic numbers in a database.

The code :

$query = "select * from questions where Answered = 'Yes' And TopicID=rand_number ORDER BY Date_Answered DESC LIMIT 5";

I want to replace rand_number with a number from the TopicID column.

Any ideas

Thanks

[Anon]

Hi,

I hope this piece of code will help you a bit, as i first 'count' the number of database results and then get a random number between the min and max.

Greetz, Paul

// banner randomize

if ($rand==1) {
$selectSQL = "SELECT bannerid FROM banners WHERE forumid=0";
$executeSQL = mysql_query($selectSQL);
$arraycount=0;

while ($arraytemp = mysql_fetch_array($executeSQL)) {
$arraycount=$arraycount+1;
}

$array=mt_rand(0,$arraycount);

}