get the name of the first field in a table

[jeff5656]

Lets say I want to get the name of the first field in a table (or the second) and assign it to a variable.

i.e., if the first fieldname in a table is called "record_number", I would want:

$first = "record_number";

 

Here's what I was able to come up with so far but not sure what to do next:

 

$sql = "SELECT * FROM $tbl ";
$result = mysql_query($sql) or die("Query failed : " . mysql_error()); 
$line = mysql_fetch_array($result, MYSQL_ASSOC);

[AbraCadaver]

Given your current code, try:

 

$first = key($line);

[AbraCadaver]

Oh, and assuming you want others later I would use this to get them all into an array:

 

$fields = array_keys($line);

[jeff5656]

That did it - thanks!