[thelist] help w/design of SQL query
Kelly Hallman
khallman at wrack.org
Fri Nov 15 11:18:01 CST 2002
On Fri, 15 Nov 2002, Tom Dell'Aringa wrote:
> Based on that I did the following code:
>
> $result = @mysql_query("SELECT menuitem.item , category.category FROM
> menuitem, category WHERE (menuitem.categoryID =
> category.categoryID)");
>
> $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;
> }
Try this:
$lastcat = "";
while($row = mysql_fetch_array($result)) {
$category = $row["category"];
$item = $row["item"];
$price = $row["price"];
if ($category != $lastcat) {
echo "Category: $category\n"; }
print "Item: $item -- Price: $price\n";
}
Your code was setting some values before any rows were fetched. Compare
the two and you should see the difference. Good luck!
--
Kelly Hallman
http://wrack.org/
More information about the thelist
mailing list