Html Characters converting

[monkeybidz]

I have this code that gives me the result I want, but when the result includes a "&" character it returns & instead. Can someone help here?

 

Here is the current code:

$getMainCats = mysql_query("SELECT id,name,issubcat FROM SAMPLE_categories WHERE parent=0 ".$adCatQuery." ORDER BY theorder ASC, name ASC");
$cnt = 0;
$catId = array();
$hasSubcat = array();

while ($row=mysql_fetch_array($getMainCats)) {
$catId[$cnt]=$row['id'];
$hasSubcat[$cnt]=$row['issubcat'];
$cnt++;
}

[gffg4574fghsDSGDGKJYM]

This should solve your problem :

 

http://www.php.net/manual/en/function.html-entity-decode.php

[monkeybidz]

Thanks for the link, I still don't know what to do or how.

[mikesta707]

well since & is the character entity for the & character, all you would really need to do is a string replace. just replace the & with &