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) = ''' ";

[Back to original message]