Try addslashes($varname). Check PHP.NET for addslashes. > -----Original Message----- > From: George Pitcher [mailto:george.pitcher@ingenta.com] > Sent: Thursday, December 19, 2002 11:24 AM > To: php-db@lists.php.net > Subject: Inserting URL into table > > > Hi, > > 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 > mail','httpNULL/www.yahoo.co.uk/')' > > 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? > > Cheers > > 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 george.pitcher@ingenta.com > > www.ingenta.com > Ingenta: Empowering the exchange of academic and professional content > online. > > > -- > 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
