Quoted Dynamic Strings are killing me (Second Attempt)
| From: | R.S. Herhuth | Date: | Mon, 22 Apr 2002 14:38:40 +0000 |
| Subject: | Quoted Dynamic Strings are killing me (Second Attempt) | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-13224@lists.php.net to get a copy of this message | ||
I have been trying to create strings dynamically by combining text and
variables. Because SQL wants single quotes surrounding the values I
have been forced to create the string as follows (all variables have
been previuosly set earlier on the page):
$query = "select bio FROM individual WHERE last_name ='".
$selectedLastname ."' AND first_name ='". $selectedFirstname ."' AND
market
='".$selectedMarket."'";
Which seems to be good to me but when I echo the query it parses out
like this:
select bio FROM individual WHERE last_name ='Appleyard
selectedFirstname=Peter selectedMarket=Atlanta' AND first_name ='' AND
market =''
What am I missing...or doing wrong? This seems so straightforward but
I'm getting beat up something horrible!
Thanks,
Ron Herhuth