Re: SELECT statement problem
| From: | Miles Thompson | Date: | Thu, 15 Aug 2002 18:25:35 +0000 |
| Subject: | Re: SELECT statement problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21157@lists.php.net to get a copy of this message | ||
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