[SOLVED] get the array key...

[jonniejoejonson]

How do i get the array key values of the following:

 

$sql = "SELECT * FROM posts";

$sql_result = mysql_query($sql,$connection)

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

........ i want the array $row key ..........

}

 

kind regards to any responders.

[Mark Baker]

$sql = "SELECT * FROM posts";
$sql_result = mysql_query($sql,$connection) 
$key = 0;
while ($row = mysql_fetch_array ($sql_result)) {
........ i want the array $row key .......... 
   $key++;
}

[ignace]

What do you mean by the $row key? $row['columnName'] or $row[0]?

[mikesta707]

array_keys($row)

 

?

[TeNDoLLA]

<?php
$sql = "SELECT * FROM some_table LIMIT 1";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$keys = array_keys($row);
print_r($keys);

[jonniejoejonson]

thanks one and all, Tendolla has pretty much what im looking for... alternatively:

 

foreach($row as $key => $value){

echo ("<BR>$key : $value");}

[Mark Baker]

Oh, so it's the column key rather than the row key