'&' Sign in _GET Parameter

From: 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

« previous php.general (#160439) next »