• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Update query is altered by safari???

#1
[eluser]bobbob[/eluser]
I have this odd thing where my update query runs ok in firefox, IE, Camino but in safari it adds a field to the update.
error message is :
Error Number: 1054
Unknown column '_' in 'field list'

There is of course no '_' in my form.
the last part of the error is where it happens:
`ip` = '67.140.22.58', `_` = '' WHERE `id` = '18'

MY query:
Code:
$id = $this->session->userdata('uid');
        $this->db->where('id',$id);
        
        $this->db->update('members',$_POST);
When I rewrite it to:
Code:
$newdata = $_POST['preferred'];
$this->db->query("UPDATE members SET preferred = '$newdata' WHERE id = '$id'");
It runs fine.

What baffles me is that safari appears to change the query.
Any ideas much appreciated.


Messages In This Thread
Update query is altered by safari??? - by El Forum - 02-12-2009, 01:20 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 01:44 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 02:09 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 07:49 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 08:41 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 08:48 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 08:58 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:07 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:15 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:28 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:38 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 09:59 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 10:40 AM
Update query is altered by safari??? - by El Forum - 02-12-2009, 12:01 PM
Update query is altered by safari??? - by El Forum - 02-12-2009, 12:49 PM
Update query is altered by safari??? - by El Forum - 02-12-2009, 04:15 PM
Update query is altered by safari??? - by El Forum - 02-12-2009, 04:23 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.