Fetching Column Names

[Skatecrazy1]

well I know this is probably very easily looked up, but I'm short on time;

is there any way to call the names of all the fields in a table into an array?

thanks.

[reaper7861]

[code]$c_sql="Select * from table where row  ='$row'";
  $res = @mysql_query($c_sql);
  $r = @mysql_fetch_array($res);
[/code]
actually i just re-read your post and think im missunderstanding you or your asking for the column names themselves or the data inside them?

[Monkeymatt]

Here is a function from a class I have that will return field names in an array.
[code]
function get_rows($table) {
$result=mysql_query("DESCRIBE `".$table."`");
if (!$result) {
echo mysql_errno().": ".mysql_error();
}
$return=array();
while (($array=mysql_fetch_array($result)) !== false) {
$return[]=$array['Field'];
}
return $return;
}
[/code]

Monkeymatt

[reaper7861]

Ah yes sorry about that matt is on it already  ::)