[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