MySQL Conditional
Posted: Tue Mar 30, 2010 10:35 am
Hello!
In the query below, which works, I want the "AND project_order.category_id = $id" part to be optional. How would I go about this?
In the query below, which works, I want the "AND project_order.category_id = $id" part to be optional. How would I go about this?
Code: Select all
SELECT project.id, project.name
FROM project
INNER JOIN project_category ON project_category.project_id = project.id
LEFT JOIN project_order ON project_order.project_id = project.id
WHERE project_category.category_id = $id
AND project_order.category_id = $id
ORDER BY project_order.order ASC