going crazy over "implode"

[dtyson2000]

Hi Folks...

I'm going nuts with this implode function. I just need to list a distinct group of cities pulled from a database as a comma separated list with no comma after the last city. So I have been playing with this and the best I can do is get it to list each city name twice. Can you see something that I'm missing?

while ($row= mysql_fetch_array($result)){
$city=mysql_result($result,$i,"city");
echo implode(', ', $row);
$i++;
}

Thanks, in advance!

[448191]

Use [i]mysql_fetch_assoc()[/i] or [i]mysql_fetch_array($result,MYSQL_ASSOC)[/i]

To elaborate:
[b]mysql_fetch_array [/b] ( resource result [, [u][i]int result_type[/i][/u]] )

[i]result_type[/i]
The type of array that is to be fetched. It's a constant and can take the following values: MYSQL_ASSOC, MYSQL_NUM, [u]and the default value of MYSQL_BOTH[/u].

Leaving "result_type" will return values twice; once with numeric, once with associative keys.