Nested loops

jonnym

I need some help doing a nested loop.
I have a mysql database table called products that looks something like this:

How would I display this:

shirt1 551
- small
- med
- large

shirt2 442
- small
- med
- large

Thanks in advance for any help!

Natty_Dreadlock

select all data from the table (SELECT * FROM products) .
Then loop through the data like this:

$list = array();
while($row = mysql_fetch_array($result))
{
$list[$row["itemno"]]["itemname"] = $row["itemname"];
array_push($list[$row["itemno"]]["sizes"], $row["itemsize"];
}

Now $list should contain a list indexed by product numbers which also stores the itemname and the possible sizes. Now, to output the data, use the following:

foreach($list as $k => $v)
{
echo $v["itemname"] . " - " . $k;
foreach($v["itemsizes"] as $size)
{
echo "   - $size";
}
}

I hope this works, since I did not test it and wrote it from the top of my head. so if u experience any errors, feel free to ask again.

jonnym

I got a parse error on this line:

while($row_=_mysql_fetch_array($result))

(your second line)

mystrymaster

no underscores

jonnym

There weren't any underscores when I tested it. For some reason, my browser (IE5.2 on a Mac OSX) puts those in on this site.

Anyway, it's not working on that line. Any suggestions anyone?

Natty_Dreadlock

please post the complete error message... and does $result contain a result of the mysql query u have to execute???

jonnym

Here's the error I'm getting:
Parse error: parse error in /opt/web/laxworld/webshare/sb_4.php on line 183

$list_=_array();
while($row_=_mysql_fetch_array($result))
{
$list[$row["itemno"]]["itemname"]_=_$row["itemname"];
// THIS IS LINE 183:
array_push($list[$row["itemno"]]["sizes"],_$row["itemsize"];
}

I tried this line by itself and didn't get an error message. itemno, itemname and itemsize are all in my query.

thessoro

are you sure "list" is not a reserved word... try other variable name instead

laserlight

Actually, I suggest that you re-structure your table.

Keep the itemname and itemno fields.
Instead of a single itemsize field, change it to 3 or more other size-related fields,
e.g. large, med and small fields with say type TINYINT DEFAULT 0
Then if one of the sizes for that particular product is available, that size's field will be set to 1.

Conversely, you could create an itemsizes table is indexed by the same primary key as the product table.

This would simplify your task of listing the sizes, and could minimize the number of rows in the products table.

EDIT:
list() is indeed a reserved word, but can be used for variable names

thessoro

list() is indeed a reserved word, but can be used for variable names

php.net: You cannot use any of the following words as constants, class names, or function names. Using them as variable names is generally OK, but could lead to confusion.

uhmmm... thanks laserlight, it's good to know about that issue... I simply thought reserved words couldn't be used as variables!! (although i always use the equivalent words in my own language and haven't come across with such dilemma)