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
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
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