why does foreach display each loop twice

[monomaniac21]

//this loop doesnt work as intended, each row displays twice, once with
a number as $key and again with key name as $key!?

Any ideas why?

$result = mysql_query("SELECT * FROM tbl WHERE id = '1' ");
while($row = mysql_fetch_array($result)) {
foreach ($row as $key =$value) {

echo "<tr><td style='width:150px'>$key</td><td>$value</td></tr>";

}

[David Haynes]

monomaniac21 wrote:

//this loop doesnt work as intended, each row displays twice, once with
a number as $key and again with key name as $key!?

Any ideas why?

$result = mysql_query("SELECT * FROM tbl WHERE id = '1' ");
while($row = mysql_fetch_array($result)) {
foreach ($row as $key =$value) {

echo "<tr><td style='width:150px'>$key</td><td>$value</td></tr>";

}

....because that's what mysql_fetch_array does. It returns each entry twice.

Change it to mysql_fetch_assoc and see what happens.

-david-

[lixuss]

just hint - try to ude var_dump or print_r to see the real content of
variable ;)
it helped me in this kind of problems many times
--
monomaniac21 wrote:

//this loop doesnt work as intended, each row displays twice, once with
a number as $key and again with key name as $key!?

Any ideas why?

$result = mysql_query("SELECT * FROM tbl WHERE id = '1' ");
while($row = mysql_fetch_array($result)) {
foreach ($row as $key =$value) {

echo "<tr><td style='width:150px'>$key</td><td>$value</td></tr>";

}

[Richard Levasseur]

David Haynes wrote:

monomaniac21 wrote:

//this loop doesnt work as intended, each row displays twice, once with
a number as $key and again with key name as $key!?

Any ideas why?

$result = mysql_query("SELECT * FROM tbl WHERE id = '1' ");
while($row = mysql_fetch_array($result)) {
foreach ($row as $key =$value) {

echo "<tr><td style='width:150px'>$key</td><td>$value</td></tr>";

}

...because that's what mysql_fetch_array does. It returns each entry twice.

Change it to mysql_fetch_assoc and see what happens.

-david-

To be more specific, it returns the results both as an indexed and
associative entry.
That means you have a numeric key and a string key for each field.
Change the fetch method or use another function, like
mysql_fetch_assoc()