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?
>
>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
