RE: [PHP] WHERE problem

> -----Original Message----- > From: Mike Shanley [mailto:thebarmy@omniversalism.com] > Sent: Monday, February 19, 2007 3:50 PM > Cc: php-general@lists.php.net > Subject: Re: [PHP] WHERE problem > > Without the single-quotes, I still get nothing returned. > > Bruce Cowin wrote: > > Are you getting an error or just nothing returned? The first thing I'd > check is if index is a numeric field and if it is, remove the single > quotes from around $randi in the where clause. > > Two things that come to mind... 1) If there are 100 records in there, is the value of the 'index' column exactly 1-100? It won't do any good to give it a random value of 1-100 if your records are numbered 101-200 :P 2) INDEX is a mysql keyword. Try putting backticks around it. "... WHERE index = $randi" If all else fails, remove the part of your code that generates the random 'index' and just use "ORDER BY RAND() LIMIT 1" in your query. HTH, Brad