PDO::prepare and SELECT WHERE LIKE

[amygdala]

Hi,

I'm trying to get the following code to work:

$sql = 'SELECT name FROM ' . DB_TABLE_CITY . ' WHERE country_id = :countryId
AND name LIKE ":city%" LIMIT 10';
$sth = $dbh->prepare( $sql );
etc...

Using:

.... LIKE "' . $city . '%" ...

Works fine, but PDO doesn't seem to recognize the :city variable with the
trailing % sign. How can I make this work so PDO recognizes :city?

Thanks in advance!

[Alvaro G. Vicario]

*** 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
--

[amygdala]

"Alvaro G. Vicario" <we*******@NOSPAMdemogracia.comschreef in bericht
news:12******************************@40tude.net.. .

*** 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.

No, sorry, that's not it. Double quotes work fine with mysql on my system
(wamp). I tried single quotes too though (escaped in this case of course).