[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