Problem with a variable that contains a '&' character

cosmos33

Hello
I got a variable that contains a '&' character.Its a company name and it : Hobbs & Hobbs
With all other company name I tested the query worked except fot this one because of that '&' char.
Her is the query :

$requeteID = mysql_query("SELECT DISTINCT NomCie,Tel, Ville,Addresse,CodePostal,SiteWeb FROM Compagnie where NomCie='$lacie'");
while ($ligne=mysql_fetch_assoc($requeteID))
{

	$leNomCie=$ligne["NomCie"];
	$laddr=$ligne["Addresse"];
	$leTel=$ligne["Tel"];
	$laVille=$ligne["Ville"];
	$leCode=$ligne["CodePostal"];
	$leSite=$ligne["SiteWeb"];

}

you can check the entire code at : http://www.pastebin.com/99853

Please help me !!!

tsinka

Hi,

what does this line
echo "lacie :xsx".$lacie;

print ?

cosmos33

lacie :xsxHobbs & Hobbs

laserlight

$lacie comes from $_GET['leNom']

Now, the $_GET array contains name/value pairs passed by the query string.
In the query string, the ampersand, &, is a reserved character.
You should use the urlencoded form, i.e. %26

cosmos33

Before sending the url I had encoded the variable. HEre is what it shows on the page url : leNom=Hobbs+%26amp%3B+Hobbs

So im not sure exactly how to do what you suggest.
Do you mean to change my query ? If so how ?
Thanks 🙂

cosmos33

http://www.pastebin.com/99913

tsinka

Hi,

did you solve the problem ?

If you're still having that problem then echo the SQL query to see how it looks like.

Thomas