Re: Mysql statement works in phpmyadmin but not in php page
| From: | James McLean | Date: | Thu, 11 Feb 2010 23:14:47 +0000 |
| Subject: | Re: Mysql statement works in phpmyadmin but not in php page | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-302026@lists.php.net to get a copy of this message | ||
On Fri, Feb 12, 2010 at 9:31 AM, Joseph Thayne <webadmin@thaynefam.org> 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.