require('includes/application_top.php');
$sql_select_categories = "SELECT categories_id, categories_name FROM tbl_doc_categories WHERE parent_id='0' AND show_status='1' ORDER BY sort_order";
$result = mysql_query($sql_select_categories) or die("Error: ". mysql_error());
$num_rows = mysql_num_rows($result);
?>
$num_count = 1;
while($categoryinfo = mysql_fetch_array($result)){
$sql_select_products="SELECT * FROM tbl_doc_products Left JOIN tbl_doc_products_to_categories ON tbl_doc_products.doc_id= tbl_doc_products_to_categories.doc_id WHERE tbl_doc_products_to_categories.categories_id='".$categoryinfo['categories_id']."' AND show_status='1' ORDER BY sort_order";
$result1 = mysql_query($sql_select_products) or die("Error: " . mysql_error());
?>