Jazzy 1012
asked on
I have many tables and one main one, how can I take there column names from the main one?
I have a table called "Call", "Win", "Com" and many others the letters in each area the field names. The table named "Main" has all the real names for the fields that are called a b c .. in the others
My question is how do I do an array where I can display a table of "Call" but instead of it showing as
It will show as
I dont want to do it as
Select * from users where 'A' is 'name' , 'B' is 'date', because there are so many letters
Call
id a b c d e f g h i j k l
Win
id a b c d e f g
Com
id a b c d e f g h i j k l m n
Main
id table column header
1 Call a date
2 Call b name
3 Com a date
4 Com b number
5 Call c address
etc...
My question is how do I do an array where I can display a table of "Call" but instead of it showing as
Call
id a b c d e
It will show as
Call
id date name address
... and so on the rest of the fieldsI dont want to do it as
Select * from users where 'A' is 'name' , 'B' is 'date', because there are so many letters
Are you using SQL Server or MySql?
ASKER
mysqli
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.