[snip] SELECT * FROM Sight_Hearing_Help WHERE 'type_help' = "Eye Exam & Glasses" AND 'board_action_date' BETWEEN "07-01-2007" AND "12-31-2007" LIMIT 0 , 60; [/snip]
Try WHERE type_help LIKE '%Eye Exam & Glasses%' and look at your dates in the database themselves even if they are varchars, they are likely formatted YYYY-MM-DD. Remove the limit first to make sure you are returning data or make it more like LIMIT 60 first. SELECT * FROM Sight_Hearing_Help WHERE type_help LIKE '%Eye Exam & Glasses' AND board_action_date BETWEEN '2007-07-01' AND '2007-12-31' LIMIT 0 , 60; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]