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@xxxxxxx> > Datum: Wed, 5 Nov 2003 13:12:45 -0500 > An: <php-db@xxxxxxxxxxxxx> > Betreff: 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php