[tpearl5]

Originally posted by Lesane


You are using an old mysql version wich don't support that way of choosing a random user. Mysql version 3.23+ supports the "order by rand" function.

Yep! that did the trick. Cept I changed it to pick from the storelottery table so it looks like:

PHP Code:

$findus=$DB_site->query_first("select *, rand() as r from storelottery where lotnumber=2 order by r limit 1;"); 


You rawk Lesane!

Now I just need to get the display on the main page working. http://degster.com/midi/board/ Nothing shows up? (should be right under member # and above newest member)