Jump to content

Checking Variable For Null


QuePID

Recommended Posts

if($var = null)  ?

 

It's not working for some reason here is the code:

if ($date=NULL) $date="0000-00-00";

if ($col_datet=NULL) $col_datet="0000-00-00";

 

Here is the error given:

Incorrect date value: '' for column 'Col_Datet' at row 1

 

What I am doing is retrieving a record from a mysql database in which the date and col_datet columns contain either a date or NULL.  When I go to update the query with either of those two fields in which they contain a null the update query fails.  So what I am wanting to do with PHP is to use a default date of 0000-00-00 instead of a NULL for the update query.

Link to comment
Share on other sites

if($var = null)  ?

 

No matter what the value of $var is, that will return TRUE.

 

Correction: no matter what the value of $var is, that will return FALSE. *stalks*

Lol. Salathe you're a funny guy. In my original post I was simply trying to correct his if statement.

Link to comment
Share on other sites

if($var = null)  ?

 

 

No matter what the value of $var is, that will return TRUE.

 

Correction: no matter what the value of $var is, that will return FALSE. *stalks*

 

Yes, with a NULL you're correct. Point being, it needs a comparison operator, not an assignment operator, to work as intended.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.