I finally found php str_replace(), and changed the code to:
data.php
while($row = mysqli_fetch_array($result)){
if($row['PRC'] == 'NLA'){
echo "<tr bgcolor='Tomato' onclick=getpartinfo2('".$mfg."','".str_replace(" ","#",$row['PARTNO'])."')>";}
elseif($row['PRC'] == 'USE'){
echo "<tr bgcolor='Yellow' onclick=getpartinfo2('".$mfg."','".str_replace(" ","#",$row['PARTNO'])."')>";}
else{
echo "<tr bgcolor='Lime' onclick=getpartinfo2('".$mfg."','".str_replace(" ","#",$row['PARTNO'])."')>";}
echo "<td>".$row['PARTNO']."</td>".
"<td>".$row['DESC']."</td>".
"<td>".$row['PARTNO2']."</td>".
"<td align='right'>".$row['PRICE']."</td>".
"<td align='right'><b>".number_format($row['PRICE']*1.20, 2, '.', ',')."</b></td>".
"<td align='center'>"."0"."</td>".
"<td align='center'>"."0"."</td>".
"<td align='center'>"."0"."</td>".
"<td align='center'>".$row['DATE']."</td>".
"<td>".$row['PRC']."</td>".
"</tr>";}
Which created a couple more problems, But was able to over come them with a
js var.replace(/#/g," ") function for my getpartinfo2() function
index.php
function getpartinfo2(mfg, partno){
var partno=partno.replace(/#/g," ");
$.post("js_php/getpart_info.php", {mfg:mfg, partno:partno}, function(data){
$("#part_data").html(data);});
}
I still think may be a jquery bug ??? or maybe a feature ?
I consider this a work around but hey it does work a dream for now, --untill I find another bug in my code -> marking as solved for now
thanks for all the help !!
jimmy