Probably because the apostrophe aka single quote is used the same way it and the double quotes (") are used in PHP, as a string delimiter.
What you're ending up with is:
SELECT nameOfPedigree FROM tbpedigrees WHERE SUBSTR(nameOfPedigree,0,1) = '
What you'd want is something more like:
SELECT nameOfPedigree FROM tbpedigrees WHERE SUBSTR(nameOfPedigree,0,1) = "'"
So maybe try this:
$sql = "SELECT nameOfPedigree FROM tbpedigrees WHERE SUBSTR(nameOfPedigree,0,1) = \"$v1\"";
See if that works any better.
-TG
= = = Original message = = =
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/
___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
