Posted by Jay Blanchard on 11/29/05 22:59

[snip]
$v1 = chr(39); //39 is apostrofe

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

Why doesn't this work?
[/snip]

Probably because the character set is misinterpreted. What happens when you
echo $v1? Try

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

• Next in forum: Re: [PHP] Howto search in SQL for a specific character?
• Prev in forum: Howto search in SQL for a specific character?
• Thread view: RE: [PHP] Howto search in SQL for a specific character?

[Reply to this message]