Hello

I am trying to let a user enter notes about an
appointment but are having errors when trying to write
their input to a database. 

The users input goes into string $appnotes

$query2="update appresult set appresult =
'$appointmentresult',product='$product',fees='0',appnotes='$appnotes'
where refno ='$refno'";

This gives the following error if the user inputs
special characters like % & or £. 

Warning: Sybase message: Unclosed quotation mark
before the character string 'To p'. (severity 15) in
updaterecord.php on line 81

Any help or pointing me to some good documentation on
this would be greatly appreciated!

__________________________________________________
Yahoo! Plus - For a better Internet experience
http://uk.promotions.yahoo.com/yplus/yoffer.html

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to