[thelist] Null entry in form
Lee Kowalkowski
lee.kowalkowski at googlemail.com
Wed Apr 25 06:00:56 CDT 2007
On 25/04/07, Santilal Parbhu <santilal at scorpioneng.co.nz> wrote:
> My problem is that when I run the script to update the results into the
> database, the database record changes from Null to a value of 0. This
> should occur for non-null entries but not for Null entries. I need a null
> entry to remain Null. Can anyone see where my code is in error? I think
> that the UPDATE is not being skipped and the NULL is being updated to 0.
>
> if ((isset($score1)) or (isset($score2))) { //If either Score1 or Score2
> is not NULL, run the update.
isset would be true, as $score1 would be *set* to *null*, use isnull.
--
Lee
More information about the thelist
mailing list