revraz Posted January 14, 2009 Share Posted January 14, 2009 I was troubleshooting someone's query and everything seemed right but the SELECT result would always have a problem. When I ran the query in phpmyadmin, I noticed the field name status was the same color coding as a function name, so I put it in backticks and it seemed to resolve the issue. The problem is, I can't find any reference to the word status being a reserved name for MySQL. Anyone else ever ran into this? Quote Link to comment https://forums.phpfreaks.com/topic/140807-using-the-word-status-as-a-fieldname/ Share on other sites More sharing options...
rhodesa Posted January 14, 2009 Share Posted January 14, 2009 the only thing i can find is: http://dev.mysql.com/doc/refman/5.1/en/show-status.html Quote Link to comment https://forums.phpfreaks.com/topic/140807-using-the-word-status-as-a-fieldname/#findComment-736980 Share on other sites More sharing options...
fenway Posted January 14, 2009 Share Posted January 14, 2009 Sounds about right. Quote Link to comment https://forums.phpfreaks.com/topic/140807-using-the-word-status-as-a-fieldname/#findComment-737033 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.