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> executing the SQL statement, but the statement still fails.  any 
AW> suggestions?  using words without a ' works fine.

$_POST['data'] = addslashes($_POST['data']);

will work - you need the quotes or the array element won't be found.

Here is a function that will addslashes to an entire array (in this
instance $_POST) if you want:

function addslash (&$item1, $key)
         $item1 = addslashes($item1);

array_walk($_POST, 'addslash');

Best regards,
 Richard Davey

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to