Echoing multiple rows from a MySQL database

[Freedom-n-Democrazy]

I'm trying to echo multiple rows from a MySQL database with no luck.

 

I've tried this code and many other combinations with it, but can't seem to get a result.

$query = "select email,mens,womens from newsletters"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) {foreach ($row as .$email. .$mens. .$womens.) {echo "$email - $mens - $womens<BR>";}}

 

What am I doing wrong?

[trq]

foreach.

[Freedom-n-Democrazy]

I've read that already.

[Freedom-n-Democrazy]

I've tried:

 

foreach ($row as $email $mens $womens)

foreach ($row as ['$email'] ['$mens'] ['$womens'])

foreach ($row as .$email. .$mens. .$womens.)

foreach ($row as ".$email." ".$mens." ".$womens.")

foreach ($row as $email . $mens . $womens)

foreach ($row as $email . $row as $mens . $row as $womens)

[trq]

Obviously your not reading it properly. The syntax is [ic]foreach ($array as $value) {}[/ci]

 

You need to use list.

[Freedom-n-Democrazy]

I have, but the examples used in it suck hard.

[jcbones]

$query = "select email,mens,womens from newsletters"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { extract($row); echo "$email - $mens - $womens<BR>";}

 

Look at extract()

[Freedom-n-Democrazy]

Will do. Thanks.