The Little Guy Posted December 24, 2009 Share Posted December 24, 2009 I can not remember how to do this, so I hope you do I have a query, and I want to add a column to the returned results that just has a value of the name of the table it came from (I can hard code the table value). so, say the table has these columns in it: - c1 - c2 - c3 and when I do my query I would like it to return these: - c1 - c2 - c3 - tbl How do you do that? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/186238-dynamic-column/ Share on other sites More sharing options...
The Little Guy Posted December 24, 2009 Author Share Posted December 24, 2009 Found it: SELECT *, 'questions' as `table` Quote Link to comment https://forums.phpfreaks.com/topic/186238-dynamic-column/#findComment-983549 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.