I'm programming a small php/mysql site wich can store data and you should be able to pull it out (as an excel file). I know how I want to do that (and have found enough information on the internet to do so), but I have one little problem.
I need to SELECT all data from a database, except for the column Id. The number of collums is also variable (at least: users van add extra columns if they need them), so I can't just SELECT * FROM [table] WHERE COLUMN IN [col_name1, col_Name2]
Or I need a function that can get this information in this format, so that I can put it into a select query.
Question
Thekk
Hello,
I'm programming a small php/mysql site wich can store data and you should be able to pull it out (as an excel file). I know how I want to do that (and have found enough information on the internet to do so), but I have one little problem.
I need to SELECT all data from a database, except for the column Id. The number of collums is also variable (at least: users van add extra columns if they need them), so I can't just SELECT * FROM [table] WHERE COLUMN IN [col_name1, col_Name2]
Or I need a function that can get this information in this format, so that I can put it into a select query.
I hope I am clear enough,
Greetings and thanks for your help,
Thekk
Link to comment
Share on other sites
1 answer to this question
Recommended Posts