gusty Posted April 24, 2006 Share Posted April 24, 2006 Hi,I'm trying to change a field in my sql table back to NULL. (default). It's if the user enters info to the wrong row and wants to change back to NULL. The code I use changes the field to 0 when executed. I've searched for this here and online and I'm not sure what's happening. I could use 0 but curious to what's happening. Here's my code. $delSQL = sprintf("UPDATE table SET field1='NULL' WHERE field2=%s", GetSQLValueString($vr, "text"));I would appreciate any pointers you can give me.Thanks,Gusty. Link to comment https://forums.phpfreaks.com/topic/8253-updating-field-to-null/ Share on other sites More sharing options...
wisewood Posted April 24, 2006 Share Posted April 24, 2006 is the field that you're trying to reset to "NULL" a numeric field such as an integer? If it expects an integer, and you tell it to use NULL, it will use 0 instead. Link to comment https://forums.phpfreaks.com/topic/8253-updating-field-to-null/#findComment-30081 Share on other sites More sharing options...
gusty Posted April 24, 2006 Author Share Posted April 24, 2006 That's it. Thanks man. Link to comment https://forums.phpfreaks.com/topic/8253-updating-field-to-null/#findComment-30091 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.