R: [PHP-WIN] Quoted Dynamic Strings are killing me (Second Attempt)

Something's going wrong... check the value of each variables ($selectedFirstname and $selectedFirstname ). Use echo to print out them. If necessary check the html source of the page with the form. -----Messaggio originale----- Da: R.S. Herhuth [mailto:ronherhuth@pop.mindspring.com] Inviato: lunedì 22 aprile 2002 16.39 A: php-windows@lists.php.net Oggetto: [PHP-WIN] Quoted Dynamic Strings are killing me (Second Attempt) 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php