Hi all,
I need to select the top 1000 records based on the usage field and update
the checked field to '1'.
I am currently doing it in 2 statements; i.e. select first then update from
a MYSQL_ROW array. How do I do it in just a single statement?
Please advice on a better way. Also...will doing
- Original Message -
From: darren [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 28, 2004 11:42 AM
Subject: select and update field in one query
Hi all,
I need to select the top 1000 records based on the usage field and
update
the checked field to '1'.
I am currently
:
Fax to:
06/28/2004 11:42 Subject: select and update field in
one query
Rhino wrote:
- Original Message -
From: darren [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 28, 2004 11:42 AM
Subject: select and update field in one query
Hi all,
I need to select the top 1000 records based on the usage field and
update
the checked field to '1'.
I am currently