hello Please can you help me about how can I get column name from database and view it using php I find this
SELECT COLUMN_NAME FROM information_schema.columns WHERE table_name = 'mohamad' ORDER BY ordinal_position
but I don't know how I can view result with php..
this problem take alot of time and it is not solvet yet... thank you very much
asked Dec 14, 2014 at 04:32 PM in Default
Which version of sql server you are using? If its 2008 and above you can read it from sys.columns table.
You can filter it for the table you need all the columns for by specifying
I am not expert in PHP so can't help displaying it on that.
answered Dec 15, 2014 at 11:27 AM