RE: [PHP-DB] limit sytax error

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:kupernik@bcn.net] Sent: Monday, January 21, 2002 11:56 AM To: php-db@lists.php.net 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: 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