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.

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

commented: have some more +5

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.