);
>
> while ( $row = mysql_fetch_array( $TICKET_WORK_INFO ) )
> {
> $ticket_id = $row["ticket_id"];
> $start = $row["start"];
> $end = $row["end"];
> $total_hours = $r
"start"];
$end = $row["end"];
$total_hours = $row["total_hours"];
$total_billable = $row["total_billable"];
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 2:26 PM
ing database is MySQL)
Rich
-Original Message-
From: Evan S. Weiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 2:15 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SELECT statement problem
Hello all,
I have this SQL statement I am trying to use and no matter what combination
I us
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. W
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