How to insert a null value in a column with double data type

lucianbeauty

Hi Guys,

My insert statement works if the user enters a value in the estimated_value field on the user form. However this is not a required field so if the user decides to leave it blank, the insert statement fails.

I need to enter a null value if the user leaves this field blank.

Can anyone assist me?


if(isset($_POST['needSubmit'])){ //un insert o update

	 $org = $_POST['org'];
	 $date = $_POST['ndate'];
	 $dateR = $_POST['rdate'];
	 $value = $_POST['value'];
	 $des = $_POST['des'];
	 $contact = $_POST['contact'];
	 $remark = $_POST['remarks'];
	 $email = $_POST['email'];
	 $phone =$_POST['phone'];
	 $place = $_POST['place'];
	 $needId = $_POST['needId'];
	// $user = 
if(!empty($needId)){  //un edit
 $sql = "UPDATE needs SET id_organization = $org, date_created = '$date', date_required = '$dateR', ";
 $sql .= " place_required = '$place', estimation_value = $value, description = '$des',";
 $sql .= " contact = '$contact', phone = '$phone', email = '$email', remarks = '$remark',";
 $sql .= " user_id = $usrID WHERE id_need = ".$needId;

}else{ //una insercion
$sql= "INSERT INTO needs(id_organization,date_created,date_required,place_required,estimation_value,";
$sql .= " description,contact,phone,email,remarks,user_id) values ";
$sql .= "($org,'$date','$dateR','$place',$value,'$des','$contact','$phone','$email','$remark',$usrID)";
}

paulnaj

How about ...

...
$sql .= " place_required = '$place'".($value? ", estimation_value = $value": "").", description = '$des',";
...

lucianbeauty

Hi Paulnaj,

I tried this but it doesn't work. i'm not sure what i'm doing wrong..🙁

paulnaj

Hi,

You need to say what went wrong. Was there an error, a warning or did it just not do what you expected.

Make sure you have error reporting turned on ... put this line

error_reporting(E_ALL);

at the top of your script (and comment it out when the site goes live).

Then, output the sql and exit just before it's used for real...

echo $sql;
exit;

See if the sql is correct.

lucianbeauty

Hi Paulnaj,

there was no error given. I tried your second suggestion and here's the output:

UPDATE needs SET id_organization = 1, date_created = '2010-10-06', date_required = '2010-10-15', place_required = 'Castries', description = 'test', contact = 'Gavin Henry', phone = '4519694', email = '', remarks = 'test', currency_id = '', user_id = 2 WHERE id_need = 24

The original sql gave the following output:

UPDATE needs SET id_organization = 1, date_created = '2010-10-06', date_required = '2010-10-15', place_required = 'Castries', estimation_value = , description = 'test', contact = 'Gavin Henry', phone = '4519694', email = '', remarks = 'test', currency_id = '', user_id = 2 WHERE id_need = 24

What that's supposed to happen is when the user saves the information it takes you to another page where the need id, organization, place required, date required and date created are seen as a header.

without the echo statement, i get some notices..(see the image file attached).

Thanks for any help u can give..