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 employee between 
start and end. What is not working?

Miles Thompson

At 02:15 PM 8/15/2002 -0400, Evan S. Weiner wrote:
>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?
>PHP Database Mailing List (
>To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to