rendered paste body<?phpclass viewall { function products($supermarket) { //Grab all categories by Ascending order $category_tblname = $supermarket. '_independent_categorie'; $query_category = "SELECT * FROM `".$category_tblname."` ORDER BY `Category_Position` ASC"; $result_category = mysql_query($query_category); while($rows=mysql_fetch_array($result_category)){ //Select all data from each category selected $product_tblname = $supermarket. '_independent_products'; $query_prodcut = "SELECT * FROM `".$product_tblname."` WHERE Category=`".$rows['Category_Name']."`"; $result_product = mysql_query($query_product); while($row=mysql_fetch_array($result_product)){ ?> <tr> <td width="25%" align="center" valign="top" style="border-right: 1px dotted silver; padding: 5px; border-top: 1px dotted silver;"> <font color="black"><?=$row["Product_Name"];?></font> </td> <td align="center" style="padding: 5px; border-top: 1px dotted silver; border-right: 1px dotted silver;" valign="top"> <div id="c13987"><?=$row["Size"];?></div> </td> <td align="center" style="padding: 5px; border-top: 1px dotted silver;" valign="top"> <div id="c13987"><?=$row["Product_Number"];?></div> </td> </tr> <? } } }}?>