RE: [PHP-WIN] Inserting symbols into a mysql database from PHP

Right, after a bit of experimentation I believe the problem is that I'm putting it through a form more than once. Basically I have an html form which which posts to a php file for verification which will then post the same data (through invisible fields) to another php file that inserts the data into database. Any better ways to do this then? Cheers Ross -----Original Message----- From: Svensson, B.A.T. [mailto:B.A.T.Svensson@lumc.nl] Sent: 15 October 2001 18:25 To: php-windows@lists.php.net Cc: r.fleming@clara.co.uk Subject: RE: [PHP-WIN] Inserting symbols into a mysql database from PHP Why doesn't the URL encoding work? >-----Original Message----- >From: Ross Fleming [mailto:r.fleming@totalise.co.uk] >Sent: Monday, October 15, 2001 7:14 PM >To: php-windows@lists.php.net >Subject: [PHP-WIN] Inserting symbols into a mysql database from PHP > > >Hi all, > >My problem is that that I have a form that takes user data and >inserts it >into a database. How can I allow quote marks to be inserted into the >database? ie if someone puts a " mark in the form field then php/mysql >recognises that as the end of the data I'm trying to insert. I tried >urlencode-ing the data before inserting it and urldecode-ing >it when reading >it, but it didn't help. > >Any suggestions? Surely this must be possible? > >Thanks in advance > >Ross > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >For additional commands, e-mail: php-windows-help@lists.php.net >To contact the list administrators, e-mail: >php-list-admin@lists.php.net > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net