[SOLVED] NULL ??

[Drewser33]

I am trying to write an update query with a null value.  But I continue to get this error:

"Incorrect date value: '' for column 'Date_Eng_replied' at row 1"  The DB is set to allow Null Values for this field.

 

I have tried defining the variable as Null in a few ways:

$replydate = $_GET['replydate'];
if($replydate == '')
{
	unset($replydate);
}

AND

$replydate = $_GET['replydate'];
if($replydate == '')
{
	$replydate = NULL;
}

AND

$replydate = $_GET['replydate'];
if($replydate == '')
{
	$replydate = 'NULL';
}

Query if needed

$query4 = "UPDATE tblopen_issue_remarks SET Fix = '$fix', Date_Eng_replied = '$replydate', Status = '$status' WHERE ID = '$threadid'";
	mysql_query($query4) or die(mysql_error());	

 

None of which will write the Null into the DB

[Bricktop]

Hi Drewser33,

 

 

Edit:

NULL needs to be assigned to a variable without quotes and kickstart has the correct MySQL query below.

[kickstart]

Hi

 

Take out the code to try and set $replydate to NULL if it is blank.

 

Then change your SQL to:-

 

$query4 = "UPDATE tblopen_issue_remarks SET Fix = '$fix', Date_Eng_replied = ".(($replydata == '') ? 'NULL' : "'$replydate'").", Status = '$status' WHERE ID = '$threadid'";

 

Problem was that your SQL had quotes around $replydate, so whatever you set $replydate to was going to land up in quotes. NULL needs to be out of quotes.

 

All the best

 

Keith

[Drewser33]

Thanks Keith!! That query worked perfect.