Try addslashes($varname). Check PHP.NET for addslashes.
> -----Original Message-----
> From: George Pitcher [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 19, 2002 11:24 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Inserting URL into table
> I'm trying to insert a URL into a char field.
> MySQLFront punts out this error with my compiled query:
> You have an error in your SQL syntax. Check the manual that
> corresponds to
> your MySQL server version for the right syntax to use near '','Yahoo
> Well there's nothing helpful in the MySQL Manual so can
> someone point me in
> the right direction.
> I am expecting that some form of encoding should take place -
> but which one?
> George in Oxford
> George Pitcher
> HERON Technical Manager
> Ingenta plc
> 23-38 Hythe Bridge Street, Oxford, OX1 2ET
> T +44 (0)1865 799137 direct
> T +44 (0)1865 799000 switchboard
> F +44 (0)1865 799134
> E [EMAIL PROTECTED]
> Ingenta: Empowering the exchange of academic and professional content
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php