WHERE (ticket.StatusID = 1 OR ticket.StatusID = 2 OR ticket.StatusID = 3 OR ticket.StatusID = 4 OR ticket.StatusID = 5 AND ticket.EntryDate >= '2004-10-17' AND ticket.EntryDate <= '2004-10-17')

WHERE (ticket.StatusID = 1 OR ticket.StatusID = 2 OR ticket.StatusID = 3 OR ticket.StatusID = 4 OR ticket.StatusID = 5) AND ticket.EntryDate >= '2004-10-17' AND ticket.EntryDate <= '2004-10-17'

$sql = "SELECT ticket.TicketID , users.uname , status.StatusName , client.ClientName , category.CategoryName , ticket.EntryDate , SUM(lineitems.LineItemHours) AS TicketTotalHours FROM obsps2_obsclient_tt_ticketdata AS ticket LEFT JOIN $lineitems_table AS lineitems ON lineitems.ParentTicketID = ticket.TicketID LEFT JOIN $client_table AS client ON client.ClientID = ticket.ClientID LEFT JOIN $status_table AS status ON status.StatusID = ticket.StatusID LEFT JOIN $category_table AS category ON category.CategoryID = ticket.CategoryID LEFT JOIN $users_table AS users ON users.uid = ticket.UID WHERE (ticket.StatusID = 1 OR ticket.StatusID = 2 OR ticket.StatusID = 3 OR ticket.StatusID = 4 OR ticket.StatusID = 5) AND ticket.EntryDate >= '2004-10-17' AND ticket.EntryDate <= '2004-10-17' GROUP BY ticket.TicketID ORDER BY EntryDate";

// GET Vars
$Users = $_GET['users'];

// Build Objects
$crit_user = new CriteriaCompo();

// loop over it and print array elements
foreach ($Users as $a)
{
echo $a;
$addfilter = new Criteria('ticket.UID', $a, '=');
$crit_user->add($addfilter, 'OR');
}
echo
;
echo $crit_user->render();

er_ticket.php?userall=3&users%5B%5D=1&users%5B%5D=2&users%5B%5D=3&users%5B%5D=4

1234
(ticket.UID = 4 OR ticket.UID = 4 OR ticket.UID = 4 OR ticket.UID = 4)

foreach ($Users as $a)
{
$crit_user->add(new Criteria('ticket.UID', $a, '='), 'OR');
}