从表中获取列值不等于零的值

Question

i have one maildigest column in my users table so..when user logged in i keep the value in session like this

$_SESSION['maildigest'] = $user->maildigest; 

so what happened is for some particular records this column value is zero..and some particular records this column value is there like 143,113

so i am tying to show the records where the maildigest column not equal to zero in this query

i keep the session value in one variable

$parentclientadmin=$_SESSION['maildigest'];

$retval = "SELECT * FROM `mdl_user`  where  maildigest IN ($id,$parentclientadmin) and trackforums='1' "; 

can anyone help me i want to get records where maildigest not equal to zero

thanks in advance...

Answer 1

You can use != there:-

$retval = "SELECT * FROM `mdl_user`  WHERE  maildigest IN ($id,$parentclientadmin) AND trackforums='1' AND maildigest !=0";

NOTE:- try to use preparedstatements to prevent from SQL Injection.