Query Failed: SELECT CATEGORYID,CATEGORYNAME,SHORTDESC,PARENTID,LASTUPDATE,SESSIONLOGID,CHANNELID,ISSPECIAL,ORDERING,ISHOME,MEMBERLEVEL,THUMBNAIL,CLICKS,ACTIVE from store_categories where ParentID= order by IsHome desc ,IsSpecial desc,CategoryName asc
Server says :1064: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 'order by IsHome desc ,IsSpecial desc,CategoryName asc' at line 1