list/each [Resolved]

I'm using the following:

PHP Code:

---

while(list($key) = each($row))
        {
            echo $key . "<br>";
        } 


---

I'm just trying to get the titles of the columns in the table (I'm building a web-based query tool). However, when I echo, I get the following results:

Quote:

---

0
Field0
1
Field1
2
Field2
etc...

---

I just want the field names and I don't understand why those indexes are in there. Help!? I guess I could just only echo the odd result, but that seems like a pain.

I think ForEach would be better suited to your problem. Each returns an array including the value and the keys. Whereas you can use ForEach to separate each pair.

There are two ways:

Code:

---

foreach($array as $key => $value)

---

Code:

---

while(list($key, $value) = each($array))

---

I think the first is much clearer. You also don't have to reset the array if you want to go through it twice.

In both cases, you simply ignore $value if you don't want it. If you only want $value and not $key, you can write the first loop as

Code:

---

foreach($array as $value)

---

Helpful, but neither of you answered the question.

The code is spitting out extra keys duplicates with the same value assigned to them, but with an integer index. That's the problem I want to get rid of. I've done a work-around using a simple boolean variable to only print out the odd ones, but I want to understand why it is printing out those duplicates in the first place.

I assume you are using the mysql_fetch_array () function. This will return an array in the form:

Code:

---

Array (
[0] => 'value1'
['field1'] => 'value1'
[1] => 'value1'
['field2'] => 'value2'
[2] => 'value1'
['field3'] => 'value3'
)

---

Istead use the mysql_fetch_assoc () function which will just return the indexes with the field names.

Actually, it's mssql (MS SQL 2K), but the same idea applies! You just saved me about 8 lines of code :D Thanks!