Updating with an empty value?
Posted: Thu Aug 07, 2003 2:27 pm
I have a certain script that (well, it should, but it doesn't) deletes certain items in a row from someones mysql database. If that made no sense, I'll try to make an image.
id|user|password|stuff|.....stuff2 |
1.some...w/e........junk...more junk
I want to delete only the part with more junk in it. This field is a text field, and I tried updating the table by going :
("UPDATE users SET stuff2='' WHERE username='$username'");
The script isn't working though >.< Is this the wrong way to go about emptying a field?
id|user|password|stuff|.....stuff2 |
1.some...w/e........junk...more junk
I want to delete only the part with more junk in it. This field is a text field, and I tried updating the table by going :
("UPDATE users SET stuff2='' WHERE username='$username'");
The script isn't working though >.< Is this the wrong way to go about emptying a field?