'&' Sign in _GET Parameter
| From: | Pushpinder Singh Garcha | Date: | Fri, 22 Aug 2003 19:05:49 +0000 |
| Subject: | '&' Sign in _GET Parameter | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-160439@lists.php.net to get a copy of this message | ||
Hello All,
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.
Thanks in advance
--Pushpinder