Re: [PHP] Mysql statement works in phpmyadmin but not in php page
[email protected] (James McLean)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
On Fri, Feb 12, 2010 at 9:31 AM, Joseph Thayne <[email protected]> wrote: > As for the backticks, they are required because of MySQL, not because of > phpMyAdmin. The issue was not that phpMyAdmin uses backticks, it is that > MySQL pretty much requires them when naming a field the same as an internal > function to my knowledge. If someone else knows of another way to designate > to MySQL that a field named HOUR is the name of a field rather than the name > of the internal function, I would love to know. Ahh I see :) Wasn't aware of that. Personally i've always been over-descriptive when designing my tables which is possibly why I've never run into that limitation :) Thanks.