Re: Select Value with 's

hi! do not quite understand your problem.. pls post some code? heres a small snippet that should work well... $qry = 'SELECT customer FROM customerList ORDER BY customer'; $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 >