Re: limit sytax error

Quoting from the MySQL manual: In MySQL Version 3.23, you can use LIMIT # to ensure that only a given number of rows are changed. So then, it's LIMIT # instead of LIMIT #,# Obviously, the way around it would be using WHERE instead of LIMIT, but I don't know your table structure so I can't provide any more details. Bogdan James Kupernik wrote: > when I try to do the update with a limit on which records, it gives me a > sytax error on the limit, is there anyway to get around this? > > UPDATE catalogs SET PROCESSED = 'Y' LIMIT $i,10 > > thanks > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net