Posted by Alvaro G. Vicario on 12/17/54 11:56

*** amygdala escribió/wrote (Wed, 23 Aug 2006 22:28:26 +0200):
> $sql = 'SELECT name FROM ' . DB_TABLE_CITY . ' WHERE country_id = :countryId
> AND name LIKE ":city%" LIMIT 10';

I've never used PDO but it seems you are using double quotes as string
separator in SQL, and that's not correct. All SQL dialects I know use
single quotes.


--
-+ http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
++ Mi sitio sobre programación web: http://bits.demogracia.com
+- Mi web de humor con rayos UVA: http://www.demogracia.com
--

• Next in forum: Re: Full Text File Search with Indexing Service on Windows (cont.)
• Prev in forum: Re: Problem with queries format
• Thread view: Re: PDO::prepare and SELECT WHERE LIKE

[Reply to this message]