Re: Selecting one row by random, where a column is set

["John W. Holmes" <holmes072000@xxxxxxxxxxx>]

Mathias Hunskår Furevik wrote:

> I've got the SQL line: $sql = "SELECT * FROM shop_items ORDER BY RAND() 
> LIMIT 1";
>
> I've got a column which is called image_large. The tricky part is, not 
> all of the image_large rows exists. Whis the query above, I want to get 
> only a row where image_large is present.

So add a WHERE clause...

SELECT image_large FROM shop_items WHERE image_large != '' ORDER BY 
RAND() LIMIT 1

--
---John Holmes...

Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals - www.phparch.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php