Welcome Guest, Not a member yet? Register   Sign In
MYSQL Error# 1364
#8

[eluser]PhilTem[/eluser]
You can't perform an insert with a where. The only thing you can do is updating or deleting a row with a where statement.

So you either want this code

Code:
$data = array(
    'websites' => $website
}
$this->db->insert('bf_users', $data);

or this code

Code:
$data = array(
    'websites' => $website
}
$this->db->where('id', $this->current_user->id)->update('bf_users', $data);

Yet guessing from your post you want to use the second code snippet.


Messages In This Thread
MYSQL Error# 1364 - by El Forum - 11-23-2012, 11:47 PM
MYSQL Error# 1364 - by El Forum - 11-24-2012, 01:55 AM
MYSQL Error# 1364 - by El Forum - 11-24-2012, 02:02 AM
MYSQL Error# 1364 - by El Forum - 11-24-2012, 03:13 AM
MYSQL Error# 1364 - by El Forum - 11-24-2012, 04:22 PM
MYSQL Error# 1364 - by El Forum - 11-24-2012, 06:24 PM
MYSQL Error# 1364 - by El Forum - 11-24-2012, 08:19 PM
MYSQL Error# 1364 - by El Forum - 11-25-2012, 12:09 AM



Theme © iAndrew 2016 - Forum software by © MyBB