That didn't do it either. I should have been more specific. I can display correct results in a HTML table. I have a Edit (A href) link to edit the current record. ie...
<?php include('../db/junction.php'); //DB Connection - MSSQL 2000 include('header.php'); ... $sql = "SELECT tblcustomer.id, tblseacust.ARC_NAME,cust, type\n"; $sql .= "FROM tblcustomer\n"; $sql .= "LEFT JOIN tblseacust ON tblcustomer.custclass=tblseacust.id\n"; $rst = mssql_query($sql); ... while($row = mssql_fetch_array($rst)) { echo "<tr>\n"; echo "<td align=center>\n"; echo "<font face=\"Arial\" size=2>"; echo "<a href=\"custmaint.php?id=$row[0]&class=$row[1]&cust=$row[2]&type=$row[3]\"><i mg alt=\"Edit\" src=\"images/edit.gif\" height=\"24\" width=\"24\" border=\"0\" /></a>"; echo "</td>\n"; Rendered results of <a href...> = http://company.com/custmaint.php?id=70&class=&cust=company T/T #29&type=OEM id is the record id class is Null so that's OK. cust=company T/T #29 type=OEM I present the info in a form... echo "<td>\n"; echo "<input type=\"text\" name=\"cust\" value=\"$cust\">\n"; echo "</td>\n"; This gives me: +------------------------+ |company T/T | +------------------------+ *Note lack of #29 which I do see in the HTML table. If I save (UPDATE WHERE id=$id) this record cust will now be company T/T All the other fields fill in correctly. Is it seeing the # as a comment? -----Original Message----- From: Richard Baskett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 3:57 PM To: Mike Smith; PHP General Subject: Re: [PHP] Escaping '#' Sign Why don't you just try: $cust2 = str_replace('#','#',$cust); That should replace all instances of # with it's html entity equivalent. If that doesnąt work then there is something else wrong with your script and we'll need to see it all! :) Rick "People who drink to drown their sorrow should be told that sorrow knows how to swim." - Ann Landers > I have a string I'm returning from a database. Some entries have # signs > in the names ie (COMPANY #42, COMPANY #43...). When I display results > all I have is COMPANY. Everything after the # is dropped off. I tried: > > If ($cust) { > $cust2=ereg_replace('#','no',$cust); > //tried $cust2=ereg_replace("#","no",$cust); too > } > > but that still returns the same thing (COMPANY). > > Also tried: > > $cust2 = preg_replace ("'&(pound|#163);'i", chr(163), $cust); > > Any help is appreciated. > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php