[thelist] help w/design of SQL query

[rudy]

> Based on that I did the following code:
>
> $result = @mysql_query("SELECT menuitem.item , category.category FROM
> menuitem, category WHERE (menuitem.categoryID =
> category.categoryID)");

you need to add     ORDER BY category, item


> $prev_cat = "";
> $category = $row["category"];
> $price = $row["price"];
> $menuItem = $row["item"];
> while($row = mysql_fetch_array($result))
> {  if($row[$category] != $prev_cat)
>   {  echo("<h2>$category:</h2>");    }
>   echo("Item: $menuItem Price: $price<br />");
>   $prev_cat = $category;  }

aha, so there is an array

you have a wee error, in that you're printing price when you haven't
retrieved it in the query, but you would have found that yourself, right?

also, ordinarily i would just let this slide, tom, but i know you're the
type of person to care about stuff like this, so i thought i'd point it
out...

that's not well-formed html you're echoing there

the items should be inside a <p>..</p> block

sure, it seems trivial, but that's the diligence one needs to bring to web
work

;o)