SELECT cat.cat_title,sub_cat.subcat_title,content.con_title,content.content,content.file from content
INNER JOIN sub_cat ON sub_cat.sid=content.sid
INNER JOIN cat ON cat.cat_id=sub_cat.cat_id where cat.align='cen'";
while($contentRow=$DB_site->fetch_array($content)){
print($contentRow['subcat_title']);
}
It will give me repeated subcat_title like
subcat_title1
subcat_title1
subcat_title2
subcat_title2
subcat_title2
subcat_title2
depending upon how many content there for that sub_cat is there any other query for escape from this kind of thing please help me
