
04-27-2004, 04:11 PM
|
 |
|
|
Join Date: Apr 2002
Location: Miami, FL
Posts: 1,107
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by Chris-FH
Hey magnus...
PHP v4.3.1 and MySQL v3.23.53 is running. Last night, I got some help, and now, it works:
Find:
PHP Code:
$result_quote = $DB_site->query("
SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
and change it to
PHP Code:
srand((double)microtime()*1000000000);
$rand_v = rand();
$result_quote = $DB_site->query("
SELECT * FROM quotes WHERE approved = 1 ORDER BY rand($rand_v)
C.
|
Yup. The earlier MySQL workaround. Good job! Glad you got it working.
|