rich-w wrote:
> I have written a simple select query...but it is not doing what I want it to:
> SELECT * FROM helpdeskticket WHERE
> (`customerid` = '$customerid') AND
> (`helpdeskticket`.`status` = 'Assigned') OR
> (`helpdeskticket`.`status` = 'Unassigned') OR
> (`helpdeskticket`.`status` = 'Can Be Closed')
> ORDER BY `helpdeskticket`.`ticketid` DESC
>
> Because its wrong i'll explain what I wish it to do. Select all fields from helpdesk ticket where
> customerid is equal to $customerid, and the status is either assigned, unassigned or can be closed.
You have your parentheses wrong:
SELECT * FROM helpdeskticket WHERE
`customerid` = '$customerid' AND (
`helpdeskticket`.`status` = 'Assigned' OR
`helpdeskticket`.`status` = 'Unassigned' OR
`helpdeskticket`.`status` = 'Can Be Closed')
ORDER BY `helpdeskticket`.`ticketid` DESC;
But this is even better:
SELECT * FROM helpdeskticket WHERE
`customerid` = '$customerid' AND
`helpdeskticket`.`status` IN ('Assigned' , 'Unassigned', 'Can Be Closed')
ORDER BY `helpdeskticket`.`ticketid` DESC;
--
felix
Please use
BBCode to format your messages in this forum.