[RESOLVED] MYSQL Update WHERE field value is empty

Running PHP version 4.4.4

Scenario
I want to update two fields game1 & game2 with 'n' for game1 and 'a' for game2 based on if field submitted is empty.

Currently using the following

<?php
mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());

$result = mysql_query("SELECT * FROM pds WHERE submitted = '0'")
or die(mysql_error());

mysql_query("UPDATE pds SET game1 = 'n' WHERE submitted = '0' ");
mysql_query("UPDATE pds SET game2 = 'a' WHERE submitted = '0' ");
?>

My understanding is that php version 4 reconizes an empty field as zero, hence '0'

However nothing is being updated at all - can anyone show me where I have gone wrong.

Thanks
Jon

UPDATE pds SET game1 = 'n' WHERE submitted IS NULL

If this don't work please tell what type the submitted field is.

Piranha - Thanks for the reply

Unfortunately, still nothing is changing - the submitted field value is 'y'

Thanks I've got it working using

UPDATE pds SET game10h = 'N' WHERE submitted!='Y'

through myphpadmin SQL rather than a .php page

Thanks again

Then I guess that the value is not NULL, that it is an empty string. If that is the case you can use the following:

UPDATE pds SET game1 = 'n' WHERE submitted = '';

I know it is resolved, but you might want to know this way as well.