mairving — Mon, 11 Nov 2002 21:46:07 +0000

Here is the query, nothing different.

<?php
$result=mysql_query(\"SELECT guestbook_message, guestbook_name from guestbook order 
by RAND() limit 1\");
$row = mysql_fetch_array($result);
?>

Mark Hensler — Mon, 11 Nov 2002 18:30:07 +0000

Like Mark Irving, I'm thinking that because the RAND() is in the SQL statement, PHP shouldn't touch it.

What kind of quotes is your SQL statement in?

mairving — Mon, 11 Nov 2002 18:26:09 +0000

Quote: Originally posted by zollet
PHP's rand() changed since PHP 4.2.0, now you don't need to seed it anymore and the syntax is [b]rand( [min value, max value )

So to get a random number between 1 and 10 you would do rand(1, 10); [/B]

Yes, I have seen that the rand function doesn't have to be seeded any more. The thing is that this really shouldn't have anything to do with PHP. It should have to do with MySQL since I am pulling the random field out with a Select statement.

zollet — Mon, 11 Nov 2002 16:12:12 +0000

PHP's rand() changed since PHP 4.2.0, now you don't need to seed it anymore and the syntax is rand( [min value, max value )

So to get a random number between 1 and 10 you would do rand(1, 10);

mairving — Mon, 11 Nov 2002 11:36:38 +0000

MySQL is 3.23.39. It can't be MySQL because when I log in via SSH and run the query in MySQL, it works fine.

Mark Hensler — Mon, 11 Nov 2002 07:08:48 +0000

just checked, you need mySQL version 3.23 to do "ORDER BY RAND()"

I can't find anywhere that mentions problems with later versions.

Mark Hensler — Mon, 11 Nov 2002 06:57:53 +0000

Very odd. What version of mySQL do the two machines have?
(I'm doubting PHP has anything to do with it)