Jay.
You're quite right about my inexperience. I only started producing PHP websites about two months ago and although it's a steep learning curve, I think I'm managing to get my head around most of it.
One (hopefully) FINAL query.
I want the following code to erase (or make 'null') the specified field when the second specified field has a specific value (in this case "blank.gif").
This code doesn't appear to be doing the trick.
Any suggestions?
Code: Select all
$query = "UPDATE tree SET photo1urn='null' WHERE photographs='blank.gif'";
$result = mysql_query($query)
or die (mysql_error());
I tried using '' instead of 'null' but there are still loads of photo1urn fields showing an incorrect value.
In case you're wondering, this PHP code is designed to optimise a section of my table to reduce the overall size and delete any unneccesary entries.
Thanks.
KD.