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



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

Reply via email to