Apply the php-function "sqlite_escape_string" on all the string data you insert/update to the database. That should to the trick.
Thanks, it just makes a '' from ' instead of \' as with MySQL. Reminds me a bit of Visual Basic...
It's the standard SQL way of escaping a ' character (MySQL (and some others) are incorrect to use \' - those need escaping of the \ character as well, which isn't necessary with the proper SQL method)
Paul VPOP3 - Internet Email Server/Gateway
[EMAIL PROTECTED] http://www.pscs.co.uk/
