Welcome Guest, Not a member yet? Register   Sign In
Update query is altered by safari???
#10

[eluser]bobbob[/eluser]
When i do it your way i get this error:

Error Number: 1054
Unknown column 'Email/Phone' in 'field list'
UPDATE `members` SET `Email/Phone` = '' WHERE `id` = '18'

which tells me that the query is is trying to use the value of preferred as the column name.
That happens in all browsers.


The only way to get it to work is this:
Code:
$newdata = $_POST{'preferred'];
$this->db->query("UPDATE members SET preferred = '$newdata' WHERE id = '$id'";

The commented line in my other posts.
I am trying to use the CI Active Record class so I would still like to know the cause


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



Theme © iAndrew 2016 - Forum software by © MyBB