Posted by "Gustav Wiberg" on 11/29/05 22:55

Hi there!

in PHP i Write..


$v1 = chr(39); //39 is apostrofe


$sql = "SELECT nameOfPedigree FROM tbpedigrees WHERE
SUBSTR(nameOfPedigree,0,1) = $v1";

Why doesn't this work?

I want the sql to select all nameOfPedigree - fields where the first
character is apostrofe (')

/G
http://www.varupiraten.se/

• Next in forum: RE: [PHP] Howto search in SQL for a specific character?
• Prev in forum: Re: Configuring PHP on a Redhat/Apache server
• Thread view: Howto search in SQL for a specific character?

[Reply to this message]