);
>
> 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
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
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
