IF statement mysql query help

[churmi]

I need some help here. I'm trying to set up an IF Statement that check to see if a field has a value or is NULL.

I though it was just like this

if ($field1)
{
}

but I can't the statement to return a true value.

can someone help me please?

Thanks

[PallaviDalvi]

You wud want to use isset() or empty().
empty() returns true when variable is NULL.
for more on empty() read this
hope this solves ur problem! 🙂