Re: [PHP] Mysql statement works in phpmyadmin but not in php page

[email protected] (Joseph Thayne)
Newsgroups php.general
Message-ID <[email protected]>
Yeah, I am a lot more descriptive now.  I ran into it quite a bit when I 
was first starting out.

James McLean wrote:
> 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.
>
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.