"Jason Wong" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> On Tuesday 07 May 2002 20:52, andy wrote:
> > Hi there,
> > is it possible to get mysql to return a record out of a table on a
> > basis?
> > I tryed:
> > select rand() ID, city
> > from data.cities
> > where country = 'CA'
> > LIMIT 1
> > but does not work though. Has anybody an idea? I tryed also to read all
> > results and do the random thing with php, but this does take forever
> > it for a couple of times)
> Try (won't work on older versions of mysql)
> SELECT something, or_another FROM table ORDER BY RAND() LIMIT 1;
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
> You knew the job was dangerous when you took it, Fred.
> -- Superchicken
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php