select and update together
| From: | James Kupernik | Date: | Mon, 21 Jan 2002 15:56:18 +0000 |
| Subject: | select and update together | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16023@lists.php.net to get a copy of this message | ||
Is it possible to select 10 records that have a NULL field and update that
field to become Y instead of NULL? If so what would this syntax be?
This is what I have now
$result = mysql_query("SELECT * FROM catalogs WHERE PROCESSED IS NULL LIMIT
$i,10");
I want to add an UPdate to it, but not sure it's possible.
Thanks for any advice you can provide.
James