RE: [PHP-DB] SELECT statement problem

2002-08-15 Thread Evan S. Weiner
To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] SELECT statement problem SELECT * FROM tickets_work WHERE employee_id = '$tech_id' AND start > '$start' AND end < '$end' ORDER BY start Which will select everything from tickets_work for a given empl

[PHP-DB] SELECT statement problem

2002-08-15 Thread Evan S. Weiner
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 An