using random numbers to present random info

[seanpaulcail]

I'm trying to generate random numbers that I use to present random info.

here's my code

//query for box 1

srand(time());
$random = (rand()%11);

srand(time());
$random2 = (rand()%11);
if ($random2 === $random){
srand(time());
$random2 = (rand()%11);}
else{


printf ($random);

printf ($random2);





$query1 = ('select * from mb_consultants where consultant_id = "$random"');
$result1 = mysql_query($query1);


$db_result1 = mysql_fetch_array($result1);


// query for box 2
$query2 = ('select * from mb_consultants where consultant_id = "$random2"');
$result2 = mysql_query($query2);


$db_result2 = mysql_fetch_array($result2);
}

then I use the following code to grab info from the database

<?php  { echo $db_result2["consultant_intro_blurb"]; }?>

but it doesn't work.

Yet if I don't use random generated numbers and I input a number from 1 to 11 for example:

$query1 = ('select * from mb_consultants where consultant_id = "1"');

it works

why doesn't my random code work?

thanks

[LordShryku]

Seems like the really long way of going

$query1 = 'select * from mb_consultants order by rand() limit 1';

[seanpaulcail]

But I need to choos between 12 different consultants, 0-11.

How would I do this with your brief code?

and I need to make sure the random numbers aren't the same number

thanks again

[LordShryku]

So there's more than the twelve in there? You could just add a where clause to it...

$query1 = 'SELECT * 
             FROM mb_consultants 
            WHERE consultant_id < 12
         ORDER BY rand() 
            LIMIT 1';

[seanpaulcail]

I making 2 requests for info to be presented on the site.

How can ensure that the same info isn't presented 2x?

thanks

[LordShryku]

On the second query, exclude the first result.

$query2 = 'SELECT *
             FROM mb_consultants
            WHERE consultant_id < 12
              AND consultant_id != '.$db_result1['consultant_id'].'
         ORDER BY rand()
            LIMIT 1';

[seanpaulcail]

it works!!

you were very helpfull