[RESOLVED] More than one table

bonio

Hi,

I have a query that returns several rows of results which have to go into different nested tables on the same page, could anyone tell me or point to a tutorial which explains how to dynamically raise/duplicate these tables and fills in the results.
Thanks.
the query;
// raise query to fill subcategory boxs etc. and put a ahref link to the product page in more info
$getsubcatbox="SELECT s.maincategory_id,s.subcategory_name, s.subcategory_id, s.subcategory_description, s.subcategory_small_image, s.category_id, s.subcategory_price_desc, s.subcategory_price,p.product_id , p.subcategory_id
FROM subcategories AS s, products AS p
WHERE p.subcategory_id = s.subcategory_id AND s.maincategory_id=$_GET[maincat_id]";

Roger_Ramjet

Learn to use the php and code tags when you post scripts.

// raise query to fill subcategory boxs and put a ahref link to the product page in more info
$getsubcatbox="SELECT s.maincategory_id,s.subcategory_name, s.subcategory_id, s.subcategory_description, s.subcategory_small_image, s.category_id, s.subcategory_price_desc, s.subcategory_price,p.product_id , p.subcategory_id
FROM subcategories AS s, products AS p
WHERE p.subcategory_id = s.subcategory_id AND s.maincategory_id=$_GET[maincat_id]";

More likely to get an answer if it is easy to read.

Roger_Ramjet

To nest results in any display format the approach is the same. You have to track the current category and modify your output when the category changes.

// set up cat and sub-cat tracking vars
$cat = 0;
$sub = 0;

// now loop through results
while ($row=mysql_fetch_array($result)) {
// is it a new cat ?
   if ($row['cat_id'] != $cat) {
        echo '<h2>'.$row['cat_name'].'</h2>';
        $cat = $row['cat_id'];
        // if it is a new cat then it is a new sub cat so force it
        $sub = 0;
   }
   // is it a new sub category
   if ($row['sub_id'] != $sub) {
       echo '<h3>'.$row['sub_name'].'</h3>';
       $sub = $row['sub_id'];
    }
    // always display the product data
    echo $row['product_name'].'<br />';
}

Now that is just a generic example. Slkot your field names etc in.

bonio

I don't know if that is suitable for my purposes, I was expecting a reply like...
You use a For Loop to reproduce the existing html for the table inserting the next row of info as long as there are rows.
Cheers.

bonio

while ($row = mysql_fetch_row($result)) {
echo '

<table>

<tr>

</tr>

</table>';

}

Roger_Ramjet

bonio wrote:
I don't know if that is suitable for my purposes, I was expecting a reply like...
You use a For Loop to reproduce the existing html for the table inserting the next row of info as long as there are rows.
Cheers.

Eh!

What you asked for was someone to show you how to fill 'NESTED' tables.
I assumed that the data was being nested in category tables which contained sub-category tables, which contained the items. I gave you the generic method for turning query results into a 'nested anything': tables, lists, even menus - just add the relevent html.

Since you did not post your table code I just used the minimum html to keep the method clear - I thought anyway.