How can I catch Null field in Mysql Options

[Darpan]

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 Code:

$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');

}



Please help me!

Thanks in advance.


Regards,

DJ