> -----Original Message-----
> From: Mike Shanley [mailto:[EMAIL PROTECTED]
> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
