You are here: Re: mysql query field name space « PHP SQL « IT news, forums, messages
Re: mysql query field name space

Posted by Tyrone Slothrop on 08/03/05 05:24

On Tue, 02 Aug 2005 20:28:36 GMT, "Oak Hall" <oak@scenicmls.com>
wrote:

>I tried it with both. With a space in the column you need the `backticks` as
>originally suggested and miss understood by me the newbie.
>
>Thanks
>Oak
>
>"JDS" <jeffrey@example.invalid> wrote in message
>news:pan.2005.08.02.19.22.57.78717@example.invalid...
>> On Tue, 02 Aug 2005 18:03:07 +0000, Oak Hall wrote:
>>
>>> This also works (now that I know what backticks are)
>>>
>>> $query="SELECT * FROM security WHERE (`User name`='$user') AND
>>> (Password='$pass')";
>>
>> First of all, please stop top-posting. Makes your rambling hard to read.
>>
>> Now, what is the name of the column? Is it "User name" or "username" or
>> "Username"?
>>
>> You lost me about two posts ago.

Amen on that one! ;-)

A little advice, Oak:

In most newsgroups you would have been flamed out of existance by the
third post. I guess PHP programmers are more patient than most.
Before you post, think about what you are trying to ask and, more
importantly, *listen*. Most of the people who answer questions have
many years experience at PHP and SQL. I have been programming
databases for 15 years and developing web applications with Perl then
PHP for 10 years and, when I am not working my butt off, I will answer
the ocassional post. Show a little respect and appreciation that we
take the time to help you out.

And, like JDS says, for God's sake, stop top posting so people can
read dialogs in the order they are added.

And, yes, get rid of those spaces in field names!

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация