'&' Sign in _GET Parameter

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_pro...=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

On Fri, 2003-08-22 at 12:05, Pushpinder Singh Garcha wrote:
> 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_pro...=PSG%20&%20Inc

no, this is not how it should look... the '&' in the above query string
is saying the variable 'name' ends and a new variable follows. If you
are submitting this in a form using method=get... it should look
something like:

?name=PSG+%26+Inc

if you are really passing this in a form using method=get, then this
should be handled automatically.

how are you accessing the passed variable?

$_GET['name'] ??