php-db | 2002122
Date: 12/19/02
- Next message: José Moreira: "[PHP-DB] trees in MySQL"
- Previous message: Hutchins, Richard: "RE: [PHP-DB] Inserting URL into table"
- In reply to: George Pitcher: "[PHP-DB] Inserting URL into table"
- Next in thread: George Pitcher: "RE: [PHP-DB] Inserting URL into table - SOLVED"
- Reply: George Pitcher: "RE: [PHP-DB] Inserting URL into table - SOLVED"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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
- Next message: José Moreira: "[PHP-DB] trees in MySQL"
- Previous message: Hutchins, Richard: "RE: [PHP-DB] Inserting URL into table"
- In reply to: George Pitcher: "[PHP-DB] Inserting URL into table"
- Next in thread: George Pitcher: "RE: [PHP-DB] Inserting URL into table - SOLVED"
- Reply: George Pitcher: "RE: [PHP-DB] Inserting URL into table - SOLVED"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

