MySQL Forums
Forum List  »  PHP

Re: submitting null value from php to MySql
Posted by: Nick Abelson
Date: October 30, 2020 02:44AM

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 . "," .

Options: ReplyQuote


Subject
Written By
Posted
Re: submitting null value from php to MySql
October 30, 2020 02:44AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.