What are tags?
R: [PHP-WIN] Quoted Dynamic Strings are killing me (Second Attempt)
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > PHP web-programming > R: [PHP-WIN] Quoted Dynamic Strings are killing me (Second Attempt) 22 April 2002 17:41:45

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

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

Alberto. Sartori 22 April 2002 17:41:45
 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.p­hp.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=P­eter selectedMarket=Atla­nta' 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


--
PHP Windows Mailing List (http://www.php.net­/)
To unsubscribe, visit: http://www.php.net/­unsub.php


Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > PHP web-programming > R: [PHP-WIN] Quoted Dynamic Strings are killing me (Second Attempt) 22 April 2002 17:41:45

see also:
[ psqlodbc-Bugs-1000522 ] Enabling…
Fw: Values in the select
SQLGetInfo buffer overflow?
пройди тесты:
see also:
Learn While You Sleep
BlueScreen Screen Saver v3.2
I thought that USB was a...

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .