|
|||||||||||||||||||||||||||
| include('include.php'); $host = $_SERVER['HTTP_HOST']; $self = $_SERVER['PHP_SELF']; $url = "http://$host$self"; $tmp = explode("/",$url); $sql_cat = "select * from category as c join product as p on p.p_cat=c.catid where p.p_access ='Unblock' and c.access = 'Unblock' group by c.catid order by c.displayorder desc"; //$sql_cat = "select * from category as c order by c.displayorder desc"; $db_cat = $obj->select($sql_cat); ?> |