insert when there is no value

[clankill3r]

I have a value $reply_to_id, sometimes it's a bigint, sometimes it's empty.

How can i insert it in the table when it's empty?

 

i tried this:

 

if($reply_to_id == ""){

  $reply_to_id = NULL;

}

 

$query = "INSERT INTO tweets VALUES (NULL, '$twitter_id', '$tweet_id', '$tweet', '$reply_to_id', '$date')";

 

but that don't work either.

 

I also tried it with setting the default value for $reply_to_id in the database to NULL.

So how can this be fixed?

 

[sunfighter]

I think you want to do an UPDATE not an INSERT

[clankill3r]

nope, a insert, cause there's nothing there yet.

[The Little Guy]

You will want quotes around null, the way you have it is a php null, not a mysql null. you will also need to remove the quotes around  $reply_to_id, and since it is an int, quotes are not required anyway.

 

How It should look.

if($reply_to_id == ""){
   $reply_to_id = 'NULL';
}

$query = "INSERT INTO tweets VALUES (NULL, '$twitter_id', '$tweet_id', '$tweet', $reply_to_id, '$date')";