Getting Field name from a select statement

[awo]

Is it possible to get the columns name from a select statement involving more than two table.
eg

SELECT a.field1, a.field2,b.field3,c.field4 
FROM a,b,c 
WHERE a.field1 = b.field1 and a.field1 = c.field1

is there a mysql statement that returns a record set containing field1, field2, field3, field4 that can be sent to an array that can be used in a php script.

[zortec]

You can use a JOIN to link the two tables together. This link will explain the different types of joins.

[awo]

it is not about the join but how to get the name of the return fields

[hielo]

refer to the first example at:
http://us3.php.net/manual/en/function.mysql-fetch-field.php