Lyleyboy Posted September 28, 2009 Share Posted September 28, 2009 Hi all, I'm looking for some guidance. I am putting together a kind of build your own query thing. In doing so I have come to one fairly major problem. I not going to know what field names should be outputted in advance. Is there a way I can find the field names from the query using php? Thanks in advance. Quote Link to comment https://forums.phpfreaks.com/topic/175767-mysql-query-result-field-names/ Share on other sites More sharing options...
Calver Posted September 28, 2009 Share Posted September 28, 2009 Hello, I'm doing this with "SHOW COLUMNS FROM users", for example. It returns a row for each column, with the column name and other information about the coulmn. Quote Link to comment https://forums.phpfreaks.com/topic/175767-mysql-query-result-field-names/#findComment-926235 Share on other sites More sharing options...
Lyleyboy Posted September 28, 2009 Author Share Posted September 28, 2009 Cool, Looks good. Got any code? Quote Link to comment https://forums.phpfreaks.com/topic/175767-mysql-query-result-field-names/#findComment-926236 Share on other sites More sharing options...
Calver Posted September 28, 2009 Share Posted September 28, 2009 Yes, but just rushing off to work. Will have to come back to you this evening! Quote Link to comment https://forums.phpfreaks.com/topic/175767-mysql-query-result-field-names/#findComment-926240 Share on other sites More sharing options...
Zane Posted September 28, 2009 Share Posted September 28, 2009 Cool, Looks good. Got any code? Hello, I'm doing this with "SHOW COLUMNS FROM users", for example. It returns a row for each column, with the column name and other information about the coulmn. Quote Link to comment https://forums.phpfreaks.com/topic/175767-mysql-query-result-field-names/#findComment-926242 Share on other sites More sharing options...
Lyleyboy Posted September 28, 2009 Author Share Posted September 28, 2009 Zanus, Oh I see. Sorry. Iv'e been a bit of a muppet there haven't I? Doh! Quote Link to comment https://forums.phpfreaks.com/topic/175767-mysql-query-result-field-names/#findComment-926247 Share on other sites More sharing options...
Calver Posted September 28, 2009 Share Posted September 28, 2009 Zanus, Oh I see. Sorry. Iv'e been a bit of a muppet there haven't I? Doh! I was trying to work out which one of us was guilty Anyway, I forgot to post the link to the thread where I learnt how to do this... http://www.phpfreaks.com/forums/index.php/topic,270259.0.html Let me know if you need anything more this evening. Quote Link to comment https://forums.phpfreaks.com/topic/175767-mysql-query-result-field-names/#findComment-926303 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.