printing out array keys

i'm trying to find a simple way of printing out the keys in an array
generated by mysql_fetch_array which returns a single row.

i.e.

while ($row=mysql_fetch_array($result) )
{

print out the $row keys and values

}

is this possible?

re: printing out array keys

kaptain kernel (63.885% quality rating):[color=blue]
>
> print out the $row keys and values
>
> is this possible?[/color]

print_r ?

/joe
--
Jordan kisses a muff from git.talk.flame in the Earl. Sixth Street is
plus-cute in Smyrna!! In El Myr, Taco Bell is elementary. Alpharetta is
swell.

re: printing out array keys

kaptain kernel wrote:[color=blue]
> i'm trying to find a simple way of printing out the keys in an array
> generated by mysql_fetch_array which returns a single row.
>
> i.e.
>
> while ($row=mysql_fetch_array($result) )
> {
>
> ### print out the $row keys and values[/color]

foreach ($row as $k=>$v) {
echo "row[$k] = $v<br/>\n";
}

[color=blue]
> }
>
> is this possible?
>[/color]

With mysql_fetch_array() you'll get both numeric and column names
indices. I only use mysql_fetch_row() for numeric indices and
mysql_fetch_assoc() for column names indices.


HTH

--
..sig

re: printing out array keys

kaptain kernel wrote:[color=blue]
> i'm trying to find a simple way of printing out the keys in an array
> generated by mysql_fetch_array which returns a single row.
>[/color]

$query = "SELECT * FROM table WHERE `key`='value' LIMIT 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result,MYSQL_ASSOC);

foreach($row as $key => $value) {
echo "key: $key , value: $value <br>";
}

HTH

--
Suni

re: printing out array keys

thanks - the foreach key=>value construct is exactly what i'm looking
for.....