Re: [PHP] Inserting a NULL value into MySQL via PHP

2005-12-07 Thread [EMAIL PROTECTED]
I tried this and it didn't work using PHP it just leaves a blank instead of a NULL setting. Any other ideas? On 11/11/05, Richard Lynch <[EMAIL PROTECTED]> wrote: > > On Thu, November 10, 2005 11:15 pm, Curt Zirzow wrote: > > > > > $sql_quoted = array(); // shiflett' -- style > > > > $myFieldVal

Re: [PHP] Inserting a NULL value into MySQL via PHP

2005-11-11 Thread Richard Lynch
On Thu, November 10, 2005 11:15 pm, Curt Zirzow wrote: > > $sql_quoted = array(); // shiflett' -- style > > $myFieldValue = isset($POST['myFieldValue'])? $_POST['myFieldValue']: > ''; > > if (strlen(trim($myFieldValue)) { > $sql_quoted['myField'] = "'" . > mysql_real_escape_string($myFieldValue)

Re: [PHP] Inserting a NULL value into MySQL via PHP

2005-11-10 Thread Curt Zirzow
On Fri, Nov 11, 2005 at 01:09:39PM +1300, Jasper Bryant-Greene wrote: > [EMAIL PROTECTED] wrote: > >Is there a way when making a MySQL database entry through a PHP script and > >there is no data to make the db treat it as NULL? > > Wouldn't this just work: > > INSERT INTO myTable (myField) VALUES

Re: [PHP] Inserting a NULL value into MySQL via PHP

2005-11-10 Thread Jasper Bryant-Greene
[EMAIL PROTECTED] wrote: Is there a way when making a MySQL database entry through a PHP script and there is no data to make the db treat it as NULL? Wouldn't this just work: INSERT INTO myTable (myField) VALUES (NULL) Jasper -- PHP General Mailing List (http://www.php.net/) To unsubscribe,

[PHP] Inserting a NULL value into MySQL via PHP

2005-11-10 Thread [EMAIL PROTECTED]
Is there a way when making a MySQL database entry through a PHP script and there is no data to make the db treat it as NULL?