Can you echo out the sql going in and any errors you're getting when the query doesn't work then post that info to this list? It'll help both you and us diagnose what might be going wrong. In addition, what datatype are the columns named start and end in your database?
(Assuming database is MySQL) Rich -----Original Message----- From: Evan S. Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 2:15 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] SELECT statement problem Hello all, I have this SQL statement I am trying to use and no matter what combination I use, I cannot get it to work. The start and end if clauses need to be grouped together. SELECT * FROM tickets_work WHERE employee_id = '$tech_id' && ( start > '$start' && end < '$end' ) ORDER BY start Anyone able to help me? Thanks! Evan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php