On Sat, Nov 23, 2002 at 04:37:01AM +0200, Octavian Rasnita wrote:
> I can do all the job with Perl, but if the link contains a "?" sign, it is
> replaced by the string "NULL" in the MySQL database and the link stored will
> be something like:
Just look up $dbh->quote(...) in the documentation.
$URL = "....";
$QUERY = "INSERT INTO foo (bar) VALUES(".$dbh->quote($URL).")";
(Or you can use prepare, which makes this even cleaner; exercise left to reader)
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
