empty field was null in mysql db now 0 in MariaDB with mysql_i
Hi
I have a form which hades certain fields, depending on set values. For example:
<?php if ($_GET['pt'] <>"5" OR $_GET['under']=="mp"){ ?>
<input name="UnderPage" type="hidden" id="UnderPage" value="" />
<?php } ?>
When on a mysql database, using mysql server behaviours, the above code returned a NULL value - bit now we've changed to MariaDB and mysql_i, a 0 is inserted instead of NULL.
The appropriate line from the update behaviour is
$InsertQuery->bindColumn("Under_PgID", "i", "".((isset($_POST["UnderPage"]))?$_POST["UnderPage"]:"") ."", "WA_NULL");
which should set a NULL value - but presumably because the value is now 0, it is ignored.
Is there a way round this, so I don't have to update all the non-admin pages that look for NULL values in this field.
Many thanks
Chris