basic PHP / MYSQL multiple tables question

[newbiePHP]

I am just begining to learn php and mysql so please forgive me if i am asking stupi question.

I have two tables:

Categories (CatID, CatName)

Products (ProdID, CatID, ProdName)

Now, I would like to list all categories and their products on one PHP page.

so it would look something like this:

Category 1
- prod 1
- prod 2
- prod 3
... etc

Category 2
-prod1
-prod2
-prod3
... etc

and so on for all the categories...

Is there a sample where I can see how this can be done? Thanks for any help!

[bodzan]

$sql1 = mysql_query("SELECT * FROM categories");
if(mysql_num_rows($sql1)>0){
     while($r1 = mysql_fetch_assoc($sql1)){
          echo "<strong>".$r1['CatName']."</strong><br />\n";
          $sql2 = mysql_query("SELECT * FROM products WHERE CatID = '$r1[CatID]'");
          if(mysql_num_rows($sql2)>0){
               while($r2 = mysql_fetch_assoc($sql2)){
                    echo "- ".$r2['ProdName']."<br />\n";
               }
          }
     }
}

[dotnotwhat]

$sql = "SELECT Categories.CatID, Categories.CatName, Products.ProdName FROM Categories, Products WHERE Categories.CatID = Products.CatID ORDER BY Categories.CatID";

$result = mysql_query($sql);

$current_catid = NULL;

while ($product = mysql_fetch_array($result))
{
    if ($current_catid != $product['CatID'])
    {
        echo "<b>".$product['CatName']."</b><br>\n"; 
        $current_catid = $product['CatID']
    }
    echo $product['ProdName']."<br>\n";
}

You might want to check your category and product names don't contain any HTML, etc.

Cheers,
Steven

[newbiePHP]

Thank you guys so much! 🙂