subject:"\[PHP\-DB\] working with ' in SQL"

Re: [PHP-DB] working with ' in SQL

2004-03-04 Thread Richard Davey

Hello Adam, Thursday, March 4, 2004, 3:30:32 PM, you wrote: AW> Hi, I have an SQL statement that is ran when data is submitted through a AW> form. When someone types in a word with an ' such as farmer's the SQL AW> statement fails. I tried $_POST[data] = AW> addslashes($_POST[data]); before AW

[PHP-DB] working with ' in SQL

2004-03-04 Thread Adam Williams

Hi, I have an SQL statement that is ran when data is submitted through a form. When someone types in a word with an ' such as farmer's the SQL statement fails. I tried $_POST[data] = addslashes($_POST[data]); before executing the SQL statement, but the statement still fails. any suggestions?