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 = '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
