Fw: entering null values
| From: | Scott M Wagner | Date: | Sat, 07 Oct 2000 17:07:19 +0000 |
| Subject: | Fw: entering null values | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3394@lists.php.net to get a copy of this message | ||
--------- Forwarded message ----------
From: Scott M Wagner <thegildedpage@juno.com>
To: mysql@lists.mysql.com
Date: Sat, 7 Oct 2000 10:07:01 -0400
Subject: entering null values
Message-ID: <20001007.100703.-429429.1.thegildedpage@juno.com>
Hello
I'm having a problem entering null values into mysql from a php script.
I'm that the solution has something to do with the addslashes function
since null values must be entered into mysql without quotes. So far
nothing has worked though. Here is one of my failed attempts:
$goal_1 = addslashes($goal_1);
$goal_2 = addslashes($goal_2);
$goal_3 = addslashes($goal_3);
$goal_3 = addslashes($goal_4);
$wu = addslashes($wu);
$sql = "
insert $table_name (id_number,name,date,goal_1,goal_2,goal_3,goal_4,wu)
values('$id_number','$name','$date','$goal_1','$goal_2','$goal_3',
'goal_4','$wu')
";
Any help would be appreciated.
Thanks,
Scott Wagner