This is basic, but need help anyway. I am using PHP and Mysql on a webpage. Here is my query which works:
$query = "SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate)) as timein FROM emp2 where mo nth(hdate)=$mymonth order by timein"; now I need to modify it so that it ignores all empnums greater than or equal to 9999. Here is what I tried, but it gives a parse error: $query = "SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate)) as timein FROM emp2 where mo nth(hdate)=$mymonth and empnum < "9999" order by timein"; thanks for any help. -Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]