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.ne
> 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/')'
>
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
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 the
