Looks like LIMIT can only contain one number, when using UPATE the offset parameter cannot be added.
http://www.mysql.com/doc/U/P/UPDATE.html UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [LIMIT #] So . . . "UPDATE catalogs SET PROCESSED = 'Y' LIMIT $i,10" would have to be "UPDATE catalogs SET PROCESSED = 'Y' LIMIT $i" -----Original Message----- From: James Kupernik [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 11:56 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] limit sytax error 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]