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! 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` Link to comment https://forums.phpfreaks.com/topic/186238-dynamic-column/#findComment-983549 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.