Explode loop from mysql

[aQ]

Hi again!

 

I have this value in a table in my database called wardrobe: Socks|Pants|Cap

 

I use explode to cut it into pieces.

explode("|", $wardrobe);

 

Then, I want to print all the pieces from "wardrobe". I do not want to do this manually, because each user has different amount of stuff in his wardrobe. Am I able to create a loop for these?

Example (this doesn't work)

while($wardrobe)
print $wardrobe[$number];
}

 

Thank you for a great forum!

[chigley]

<?php
$q = mysql_query("SELECT wardrobe FROM table WHERE user = '$username'");

echo "<pre>";

while($row = mysql_fetch_assoc($q)) {
$bits = explode("|", $row["wardrobe"]);
foreach($bits as $item) {
  echo "$item\n";
}
}

echo "<pre>";

?>

[aQ]

Well. It prints all the items in wardrobe, BUT it prints it hundreds of times. Any ideas?

[chigley]

Probably because there is more than one entry in the database?

[aQ]

The wardrobe-field in the users table has info|info|and some other info

[chigley]

Yes but if there are duplicate rows in the database, more than one will be outputed. So if this is your database:

 

Table: table
+---------+
|wardrobe |
+---------+
|value1   |
|value2   |
+---------+

 

Then both values will be outputted!

[marcus]

How many "wardrobe" pieces are actually being printed out, and how many do you actually have it in your field.

[aQ]

There is two pieces. with a | in between. That is where I want it to explode.