printing out array keys

kaptain kernel

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?

Jul 17 '05 #1

Disco Plumber

kaptain kernel (63.885% quality rating):

print out the $row keys and values

is this possible?

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.

Jul 17 '05 #2

Pedro Graca

kaptain kernel wrote:

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
foreach ($row as $k=>$v) {
echo "row[$k] = $v<br/>\n";
}

}

is this possible?

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

Jul 17 '05 #3

Juha Suni

kaptain kernel wrote:

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.

$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

Jul 17 '05 #4

kaptain kernel

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

Jul 17 '05 #5