Thanks for the link,

$link = $row['company'];
<a href=\"full_profile_1.php?name=', urlencode($link),' \">

However this does not seem to work / what am I missing ?

Thanks
-Pushpinder



On Friday, August 22, 2003, at 03:23 PM, CPT John W. Holmes wrote:

From: "Pushpinder Singh Garcha" <[EMAIL PROTECTED]>

  I am using an application where I retrieve user profile from a MySQL
DB using the Company Name .  I pass the name of the company to the PHP
script as a '$_GET' parameter. e.g. when the name of the company is
'IBM'. , the URL with the query string would look like :
http://masterstream.com/CRM/full_profile_1.php?name=IBM

Now one of the records had a name : PSG & Inc. , in this case the URL
with the query string would look like
http://masterstream.com/CRM/full_profile_1.php?name=PSG%20&%20Inc.

However in the case of the latter I am not able to pull out any records
from the MySQL database. It says that "no records with the name were
found". I went ahead and tweaked the name of the company, to remove
the "&" sign in 'PSG & Inc.' Now the query works fine. Can some one
throw some light here. I am sure something minor is to be done when
passing the name of the company in the parent script.

The & character separates variables in the query string, so it must be encoded if it appears in the data. Take a look at http://us2.php.net/urlencode

---John Holmes...


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



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



Reply via email to