RE: [PHP-DB] Inserting URL into table

2002-12-19 Thread Hutchins, Richard 
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
 
 
 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  [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

Re: [PHP-DB] Inserting URL into table

2002-12-19 Thread 1LT John W. Holmes 
 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?

Probably an addslashes() issue, but what's your whole query look like?

---John Holmes...


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Inserting URL into table - SOLVED

2002-12-19 Thread George Pitcher 
Well, all I can say is Doh! as Homer would put it! Somehow when I created my
table, the link_url field was set is INT with a length of 3! Changing it to
a much longer char field sorted it.

Cheers

George


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php