Reputation: 336
Something similar has been asked before but not answered and it's not 100% the same, what i have is an SQL like:
SELECT * FROM table1 JOIN table2;
I know that I can get the columns of a table using DESC
, DESCRIBE
or SHOW
BUT, that function doesn't allow multiple tables neither SQL queries.
Upvotes: 1
Views: 114
Reputation: 5256
Both mysqli::fetch_assoc()
and PDOStatement::fetch()
can return a row as an associative array, which means that the columns are indexed by column name rather than by number. You can then use the array_keys()
function to extract a list of the column names, in order, from the row.
Upvotes: 2