[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) = ''' "; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
