Re: Select Value with 's
| From: | pete M | Date: | Thu, 06 Nov 2003 12:58:23 +0000 |
| Subject: | Re: Select Value with 's | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31472@lists.php.net to get a copy of this message | ||
why the backticks and not quotes ?????
pete
Ma wrote:
hi! do not quite understand your problem.. pls post some code? heres a small snippet that should work well... $qry = 'SELECTcustomerFROMcustomerListORDER BYcustomer'; $res = mysql_query($qry); while($customer = mysql_fetch_object($res)) {echo stripslashes($res->customer).'<br>'."\n";} hth? _ma # life would be easier if i knew the source code...Von: "Aleks @ USA.net" <Aleks.k@usa.net> Datum: Wed, 5 Nov 2003 13:12:45 -0500 An: <php-db@lists.php.net> Betreff: [PHP-DB] Select Value with 's This is a basic question but I am all messed up and need to be straightened out.. Have a select field called customer that works great except when there is a ' in the customer name. Have tried addslash and stripslashes but I think I might be using them wrong. If I addslash to the select value, the value received but the result page is truncated up to the point of the ' ..... Can someone refresh me on the correct use of add and strip slashes... please?? Thanks Aleks