Re: mysql escape character \'

thanks everybody for your help, i actually had the solution before posting :)) my question was not a 'how to' but why do we need to escape single quotes on unix systems and not on windows using the same version of php and mysql? At 21:44 07/08/01, you wrote:

Dear PHP-General (bit of strange, uh?), I guess what you are looking for is this: http://www.php.net/manual/en/function.addslashes.php Hope it helps. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 ----- Original Message ----- From: "hassan el forkani" <webmaster@warmafrica.com> To: <php-general@lists.php.net> Cc: <mysql@lists.mysql.com> Sent: Tuesday, August 07, 2001 4:32 PM Subject: mysql escape character \' greetings; i'm not sure if this is a mysql or php issue so i'm posting to both lists, i'm developping a community web site with news, forums......; while working on the admin section i noticed this behaviour: on my hosting platform (linux) i need to replace single quotes by \' to properly insert the data into the database and avoid errors on my dev machine (win98) there is no need to do so as single quotes are properly inserted and attempting to escape them actually inserts \' instead of '; so the same code does not have the same output on windows and linux can someone explain?? --------------------------------------------------------------------- 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 <mysql-thread81834@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-hinz=js-webshop.com@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <mysql-thread81880@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-webmaster=warmafrica.com@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php