Hello All
I need to display all rows in the following statement where userstatus should not be 1 and user_del_status should not be 1 then only the particular login process must be occured otherwise i shoud get an error stating the login is not allowed for the user.
$query= "select * from tbl_usns_users where username ='".$_POST['username']."' and userpassword='".$_POST['pass']."' and userstatus!=1 and user_del_status!=1";
echo $query;
$result=mysql_query($query);
//$result= odbc_exec($connects,$query);
//$fetchrow = odbc_fetch_array($result);
//echo $fetchrow['jaga'];die;
$numr=mysql_num_rows($result);
$fetchrow=mysql_fetch_array($result);
i am getting following error can anybody solve my error
please help me
Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Apache Group\Apache2\htdocs\usns\member\checklogin.php:22) in C:\Program Files\Apache Group\Apache2\htdocs\usns\member\checklogin.php on line 46
please find my code as an attachment
thanks in advance to all