generating sql statement with zero value

[Anon]

Hi,

I've searched the archives and don't see an answer.

Could someone take a look and let me know an idea or 2 on ways to handle this sql generation , please?

I'm building a string like this:

$updateQstr = "UPDATE table SET ";
if ($LineNo1)
{ $updateQstr = updateQstr . "table.field = '$LineNo1' " ;
}
rest of sql statement built after this

The bug is occurring when the value coming in from web is $LineNo1 = '0'. Essentially user tries to update a value to zero and the string builder does not honor the value because php sees the value as not being set.

I have tried:
if (ereg("[[:digit:]]", $LineNo1))
{build string}

but this doesn't seem to work correctly.

Please help.

[[deleted]]

use 'isset()'

if (isset($LineNo1))
{
// lineno was set (it contains a value)
}
else
{
// lineno was not set
}

[rrijnders]

Use <b>empty()</b> to check if they entered anything on the form at all.

Use <b>is_numeric()</b> to make sure it is a numeric value.

I don't think is_set() will work if the value is coming in from a form because php will simply <i>set</i> the variable to blank if they didn't enter anything (but it will always be <i>set</i>, none the less).

-- Rich