JimmyA

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

function UserChoice1(){ 1 = 0; // 1==0 you are asking does 1 = 0 1 = 1++; // 1==1++ here you are asking does 1 = 1++ }

Thank you - for your replies and attention, there is no java running on this code yet, the same thing happens on 5 other computers I have here, all are ubuntu 10.04 with firefox browsers - non of the other computers have any debuging or other addons installed, (I finally got away from win so can't test with that, One other machine has deibian sqeeze with Iceweasel and epiphany browsers on it and they both do the same thing as the other machines with firefox - there is no error or anything just nothing happens when I mouse click on the returned row of the generated table -> onclick=getpartinfo2('pl_Test','24 009 103-S') if you look at this part of the code <tr bgcolor="Lime" 103-s')="" 009="" onclick="getpartinfo2('pl_Test','24"> <td>24 009 103-S</td> etc... this is what is sent back from the php function the code works perfectly if there are no spaces in the partno,the only other thing that touches this before the page gets it back is jquery-1.9.0.js -> i don't know what it does to it, using ajax style programming to dynamically create the table on the page. mabey a bug in the jquery lib ?? I'm just totally lost, I just want to return a simple string from my php function and I can't get it right.

Yes, all returnd values in the database are correct and verified, the problem is not the returned values -> but with the php generated code returned to the calling page (if that is the correct term for this) like I said I am only about 3 weeks old with programming. Thanks, Jimmy

Hello everybody, Sorry so long a post - I did not know how to shorten I am trying to make a ??Web App?? I think it would be called. it's a part pricing look up Web Page. Reported by webmin 1.620 Operating system Debian Linux 6.0 Kernel and CPU Linux 2.6.32-5-686 on i686 Apache version 2.2.16 MySQL version 5.1.66 PHP5 version ???? // did not know where to find This is the portion of the code giving me problems: onclick=getpartinfo2('" .$mfg. "','" .$row['PARTNO']. "')>"; and is used like this: while($row = mysqli_fetch_array($result)){ $part = $row['PARTNO']; // Added this just trying somethimg!!! echo $part; // This outputs to screen and is correct if($row['PRC'] == 'NLA'){ echo "<tr bgcolor='Tomato' onclick=getpartinfo2('" .$mfg. "','" .$row['PARTNO']. "')>";} elseif($row['PRC'] == 'USE'){ echo "<tr bgcolor='Yellow' onclick=getpartinfo2('" .$mfg. "','" .$row['PARTNO']. "')>";} else{ echo "<tr bgcolor='Lime' onclick=getpartinfo2('" .$mfg. "','" .$row['PARTNO']. "')>";} echo "<td>".$row['PARTNO']."</td>". Rest of code... I have tryed $row['PARTNO'] // error below $part // var I set above // error below strval($part) // error below "$row['PARTNO']" // server error {$row['PARTNO']} // server error '{$row['PARTNO']}' // server error "{$row['PARTNO']}" // error below and really many more that I can not remember table lookups and returned values all work correctly it's the (onclick=) code echo'd back to the calling page I have a problem with If I enter a partno like... partno entered '230004-s' I get this: onclick="getpartinfo2('pl_Test','230004-S')" // this is the expected output and when I click on the row (onclick event) the getpartinfo2() works perfectly If I enter a partno that has spaces in it... partno entered '24 009 103-s' and when I click the row (onclick event), I get this error -> getpartinfo2('pl_Test','24 SyntaxError: unterminated string literal http://192.168.1.200...jquery-1.9.0.js Line 3811 If I look at firebug->Console->Response -> it shows this, onclick=getpartinfo2('pl_Test','24 009 103-S') // what I want for this portion of the output -> which is correct but using firefox->tools->web devolper extension->view source->veiw generated source the code says onclick="getpartinfo2('pl_Test','24" 009="" 103-s')="" and in firebug->html - it looks like this <tr bgcolor="Lime" 103-s')="" 009="" onclick="getpartinfo2('pl_Test','24"> <td>24 009 103-S</td> <td>CLOSURE PLATE ASSEMB</td> <td></td> <td align="right">279.42</td> <td align="right"><b>335.30</b></td> <td align="center">0</td> <td align="center">0</td> <td align="center">0</td> <td align="center">12-12</td> <td></td> </tr> It's almost like PHP is trying to do math operations on what is suppose to be a string I have only been working with html-php-mysql for about 3 weeks, and the last week on this single problem Thanks for any help I could get; Jimmy