Posted by David Haynes on 08/04/06 10:46

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-

• Next in forum: display provider name form hostname
• Prev in forum: why does foreach display each loop twice
• Thread view: Re: why does foreach display each loop twice

[Reply to this message]