Problem reading null

[jrahma]

Hi,

I have a table with floor_id field.

The floor_id is null and I am trying to read it

when I read it using where floor_id = NULL I don't get the correct result but when I try where floor_id IS NULL it's working

so how can I do when passing a parameter like where floor_id = param_floor?

Thanks,
Jassim

[NogDog]

You may need some if/else type logic to set up the SQL in the script, e.g.:

$sql = "SELECT * FROM some_table WHERE ";
if(is_null($input) {
    $sql .= "the_column IS NULL";
}
else {
    $sql .= "the_column = :input";
}
$stmt = $pdo->prepare($sql);
if(!is_null($input)) {
   $stmt->bindParam(":input", $input);
}
$stmt->execute();