get field names when table empty

[Gasolene]

is there any way to get all field names in a mysql resultset when table is empty and inner join was used?

ex:

sql = 'select * from mytable inner join othertable on leftval=rightval';

$result = mysql_query($sql);

$i = mysql_num_fields() // returns false when no results

// describe table doesn't work for inner joins

[bastien]

try something like

sql = 'select * from mytable inner join othertable on leftval=rightval';

$result = mysql_query($sql);

foreach($mysql_field_name as $field){
  echo $field."<br>";
}

[Gasolene]

mysql_field_name is a function that requires parameters and returns a string.

mysql_field_name( $link, 0 ) returns false if there are no records in table