how to retrieve data containg ampersand from mysql table using php

[benoypaul]

$CAT='Bath & Body';
sql="select * from Products where Category = '$CAT';
$result=mysql_query($sql);

When I am running above code , I got an error. When I am removing '&' from $CAT , it is working fine. I wish to know how to include ampersand in mysql data.

Thanks in advance

[Markus]

$CAT='Bath & Body';
sql="select * from Products where Category = '$CAT';
$result=mysql_query($sql);

When I am running above code , I got an error. When I am removing '&' from $CAT , it is working fine. I wish to know how to include ampersand in mysql data.

Thanks in advance

Try preceeding it with a backslash
[php]
$CAT = "something \& something else";
[/php]

[benoypaul]

Sorry. It is not working

[Markus]

Sorry. It is not working

Strange
What error do you get?

[benoypaul]

I am using this php code in a javascript function. I got the error "object expected". When removing ampersand from $CAT or commenting $sql stament, then code is working properly.

[Markus]

I am using this php code in a javascript function. I got the error "object expected". When removing ampersand from $CAT or commenting $sql stament, then code is working properly.

Can you please show the full code
using the proper code tags

[benoypaul]

function removeAllOptions(selectbox)
{
	var i;
	for(i=selectbox.options.length-1;i>=0;i--)
	{
		//selectbox.options.remove(i);
		selectbox.remove(i);
	}
}


function addOption(selectbox, value, text )
{
	var optn = document.createElement("OPTION");
	optn.text = text;
	optn.value = value;
   
	selectbox.options.add(optn);
}


function SelectEditProduct()
{
removeAllOptions(document.editproducts.productname);
addOption(document.editproducts.productname,"","select");
<?php
include_once("database.php");
$sql="select * from ProductCategory ";
$result1=mysql_query($sql) ;
while ($rows1=mysql_fetch_row($result1))
{
echo "if(document.editproducts.categoryname.value == '$rows1[1]'){";

$sql="select * from Products where Category ='$rows1[1]'";  // THIS LINE SHOWS ERROR
//$sql="select * from Products where Category='Bath \& Body'";
 
$result=mysql_query($sql);
while ($rows=mysql_fetch_row($result))
{
 echo "addOption(document.editproducts.productname,'$rows[1]', '$rows[2]');";
}
echo "}";  
}

?>

}

ProductCategory table contains some data with ampersand ($rows1[1]). This causes errors

[Markus]

Can you show me the output you get on the page source?
I'm still not understand your problem.
Is the error with javascript or php?

[benoypaul]

It is a javascript error. When we removing $sql ="..." statement, there is no errors. URL of this code is http://www.markdickson.com/adminpanel/editproduct.php

Error occur when we changing productcategory

[Markus]

It is a javascript error. When we removing $sql ="..." statement, there is no errors. URL of this code is http://www.markdickson.com/adminpanel/editproduct.php

Error occur when we changing productcategory

If it's a javascript error, you should ask in the javascript forum.

[benoypaul]

Thanks a lot for your help