Code: Select all
$sql = "SELECT category.ctitle, page.id, page.title
FROM category LEFT JOIN page ON category.id = page.catid
WHERE category.id>1 AND category.public=1 AND category.deleted=0
ORDER BY category.ord, page.ord";Code: Select all
$sql = "SELECT category.ctitle, page.id, page.title
FROM category LEFT JOIN page ON category.id = page.catid
WHERE category.id>1 AND category.public=1 AND category.deleted=0
AND page.public=1 AND page.deleted=0
ORDER BY category.ord, page.ord";Any hints?
Thanks.
Edit: Um... well, that was embarrassingly simple. Solution:
Code: Select all
$sql = "SELECT category.ctitle, page.id, page.title
FROM category LEFT JOIN page
ON category.id = page.catid AND category.public = page.public AND category.deleted = page.deleted
WHERE category.id>1 AND category.public=1 AND category.deleted=0
ORDER BY category.ord, page.ord";