Re: submitting null value from php to MySql

[Nick Abelson]

thanks for confirming that 123-reg aren't offering a good service. I have had my suspicions for a while.
I am using this workaround which seems to be working:

if (empty($minvalue))
{
$minvalue = 'null';
echo "min valie is what: " . $minvalue;

}
else
{
$minvalue = "'" . $minvalue . "'";
// echo "min valie is what:11" . $minvalue;

then in the SQL statement I have removed the single quotes for these values.
"','" . $habitid . "'," . $minvalue . "," .