You are here: Re: HELP: pesky SQL syntax error using PHP variables « PHP Programming Language « IT news, forums, messages
Re: HELP: pesky SQL syntax error using PHP variables

Posted by Gary L. Burnore on 12/17/61 11:52

On Mon, 10 Jul 2006 21:27:25 GMT, "Frankie" <frankie66@earthlink.net>
wrote:

>Thank you soooo much!
>
>Those darn quotes...so confusing. I'm delirious from staring at this query
>all morning.


Thank the newsgroup by not top posting.


>F.H.
>
>"David Haynes" <david.haynes2@sympatico.ca> wrote in message
>news:pvzsg.91993$%16.23940@fe76.usenetserver.com...
>
>> Your FROM clause would be FROM 'foo'. It should be FROM foo instead.
>>
>> Try:
>> $query = sprintf("SELECT itemNumber, entryDate, modifyDate,
>> thumbnailURL, title, price FROM %s WHERE itemNumber = '%s'",
>> $_POST['selectCategory'], $_POST['tfItemNum']);
>
--
gburnore at DataBasix dot Com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
Official .sig, Accept no substitutes. | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ 0 1 7 2 3 / Ý³Þ 3 7 4 9 3 0 Û³
Black Helicopter Repair Services, Ltd.| Official Proof of Purchase
===========================================================================

 

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

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