sql this... arggh

[Roaddoctor]

How can I add this

 

categories_status = 1

 

into this

	 $quotes = (defined('QUOTES_CATEGORY_NAME') ? " where cd.categories_name NOT LIKE '" . QUOTES_CATEGORY_NAME . "' " : '');
$sql = "SELECT c.categories_id as cID, c.date_added, c.last_modified as last_mod
	 FROM " . TABLE_CATEGORIES . " c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.categories_id = cd.categories_id
			 " . $quotes . "
ORDER BY c.parent_id ASC, c.sort_order ASC, c.categories_id ASC";

 

I can't seem to make it work.

[Jack_mcs]

Change

on c.categories_id = cd.categories_id

to

on c.categories_id = cd.categories_id where c.categories_status=1

[♥bruyndoncx]

and change the 'where' in the first line to ' and '

[Roaddoctor]

Thank you to both of you... I had tried the change Jack suggested... it was the missing line 1 change to 'and' that goobered me up. Good catch!