The trick is your using the wrong ' instead you need ` ... go away from kl;->' and go to `->123 ;) The key above the (Tab) key, or the key next to the number 1 above the q. so ... $query="SELECT * FROM bibleverses WHERE `used` = 0 ORDER BY RAND() LIMIT 1"; When I first learned this also I was fooled and used ' instead of `. But in some cases you don't need to use it also. I hope this covers it! Sorry if someone else has responded before me. I might of been a bit slow! ;) Jerry >From: "Ron Piggott" <ron.php@xxxxxxxxxxxxxxxxxx> >Reply-To: "Ron Piggott" <ron.php@xxxxxxxxxxxxxxxxxx> >To: "Webmaster" <webmaster@xxxxxxxxxxx> >CC: "PHP DB" <php-db@xxxxxxxxxxxxx> >Subject: Re: UPDATE command >Date: Fri, 17 Jun 2005 23:47:31 -0400 > >This is kind of interesting ... > >$query="SELECT * FROM quiettimequotation WHERE used = 0 ORDER BY RAND() >LIMIT 1"; > >works; > >$query="SELECT * FROM bibleverses WHERE 'used' = 0 ORDER BY RAND() LIMIT >1"; > >doesn't! Having the ' around used makes that select command fail --- but >the UPDATE command requires it! > >Thanks for those of you who responded to my question below. I am creating >a >mailing list for my web site that I am wanting each entry which is randomly >selected from the database to only be used once and not be available again >until the entire list has been used. I needed the UPDATE command to change >the used column all back to 0 again once the last entry had been selected >from the database. I think I like programming mySQL stuff :) Ron > >--- > > >Does the UPDATE command only change one row or each occurance if the the > >criteria repeat itself through the table? > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php Send instant messages to your online friends http://au.messenger.yahoo.com
