Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002122

RE: [PHP-DB] Inserting URL into table From: Hutchins, Richard (Richard.Hutchins <email protected>)
Date: 12/19/02

Try addslashes($varname). Check PHP.NET for addslashes.

> -----Original Message-----
> From: George Pitcher [mailto:george.pitcher <email protected>]
> Sent: Thursday, December 19, 2002 11:24 AM
> To: php-db <email protected>
> 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 <email protected>
>
> 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