php-db | 2002122
Date: 12/19/02
- Next message: Hutchins, Richard: "RE: [PHP-DB] Inserting URL into table"
- Previous message: Terry Romine: "Re: [PHP-DB] picture into mysql (file address)"
- Next in thread: Hutchins, Richard: "RE: [PHP-DB] Inserting URL into table"
- Maybe reply: Hutchins, Richard: "RE: [PHP-DB] Inserting URL into table"
- Reply: 1LT John W. Holmes: "Re: [PHP-DB] Inserting URL into table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Hutchins, Richard: "RE: [PHP-DB] Inserting URL into table"
- Previous message: Terry Romine: "Re: [PHP-DB] picture into mysql (file address)"
- Next in thread: Hutchins, Richard: "RE: [PHP-DB] Inserting URL into table"
- Maybe reply: Hutchins, Richard: "RE: [PHP-DB] Inserting URL into table"
- Reply: 1LT John W. Holmes: "Re: [PHP-DB] Inserting URL into table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

