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)


-----Original Message-----
From: Evan S. Weiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 2:15 PM
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?



PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to