asked
get column name and view it using php
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
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 OBJECT_ID('your_table_name_here') I am not expert in PHP so can't help displaying it on that.
15 People are following this question.
