SELECT folder_id,content_name,folder_page_id,
      (
	    SELECT COUNT(*) 
		  FROM site_page 
		  LEFT JOIN site_folder AS c
		  ON c.folder_id = page_folder_id
		  WHERE page_folder_id = a.folder_id
		  AND folder_site_id = 
		  AND page_hidden = "1"
		  AND page_active = "1"
		  AND page_order > 0
	  ) AS pages,
	  (
	    SELECT COUNT(*) 
		  FROM site_folder AS b 
		  WHERE b.folder_parent_folder_id=a.folder_id
		  AND b.folder_active = "1"
		  AND b.folder_hidden = "1"
		  AND b.folder_order > 0
		  AND b.folder_site_id = 
	  ) AS folders
    FROM site_folder AS a
	LEFT JOIN site_folder_content ON folder_id = content_folder_id
    WHERE folder_order>0 
	AND folder_hidden = "1"
	AND folder_active = "1"
    AND folder_parent_folder_id=0
	AND folder_site_id = 
    ORDER BY folder_order<br />You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND page_hidden = "1"
		  AND page_active = "1"
		  AND page_ord<br />
<b>Warning</b>:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/services7/webpages/e/n/envisionsales.com/public/envision/menu/menu_items.php</b> on line <b>137</b><br />
var MENU_ITEMS = [];