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

Posted by Oak Hall on 08/02/05 17:45

; after $pass='1234'
"Oak Hall" <oak@scenicmls.com> wrote in message
news:jCLHe.3364$j21.261@news01.roc.ny...
> Yes, didn't work.
> ex:
> $user='My Name';
> $pass='1234'
> $query="SELECT * FROM security WHERE 'User Name'='$user' AND
> Password='$pass'";
>
> finds no matches.
>
> finds some if I take out the user name and just look for a matching pass
> word.
>
> Thanks
> Oak
>
>
>
> "Tyrone Slothrop" <ts@paranoids.com> wrote in message
> news:ukvue196h9tde0tsqcbu02fk9d55j43d88@4ax.com...
>> On Tue, 02 Aug 2005 13:54:34 GMT, "Oak Hall" <oak@scenicmls.com>
>> wrote:
>>
>>>I want to query a mysql table that has a space in the name of the field.
>>>I
>>>ge no results. What is the syntax for this?? Thanks in advanced Oak
>>
>> Have you tried `backticks`?
>>
>>>PS I am switching some things from paradox to PHP. Any migration
>>>suggestions??
>>
>> Can't help youi there.
>>
>
>

 

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

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