Mysql: How I can search NULL value (Urgent)

[djdarpan]

Hi,

I am new with MySql and PHP.

I have a problem while I am checking NULL value in database.

I need

If there is empty field in my table row return message "Somthing "and if there is no empty field return "Nothing". Can anyone help me.

I write a query but it does not work. My query is:

[PHP]

$query = sprintf("SELECT * FROM `jstatus` WHERE `page` IS NULL AND `etime` IS NULL ");
$ss = mysql_query($query);
$cc=mysql_num_rows($ss);
if($cc= FALSE){

header('location:login_success.php?title=go??sessi onid=0d0a0r0p0a0n');
} else{

header('Location:job_success.php');

}

[/PHP]

Please help me!

Thanks in advance.


Regards,

DJ

[michaelb]

I think you can use the CASE statement, follow these links for details:
http://dev.mysql.com/doc/refman/5.0/...statement.html
http://dev.mysql.com/doc/refman/5.0/...functions.html