RE: [PHP-DB] Inserting URL into table
| From: | Hutchins, Richard | Date: | Thu, 19 Dec 2002 16:27:36 +0000 |
| Subject: | RE: [PHP-DB] Inserting URL into table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24281@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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
>