Welcome Guest, Not a member yet? Register   Sign In
query builder class update
#1

I am also having a problem with the code below which uses the query builder class.

$userid=(string$result->successResponse->user->id;
$this->db->set('fusion_userid'$userid);
$this->db->where('email'$email);
$this->db->update('employees');


I have checked the $email and the $userid and they appear fine. But after the update (which has no error code) I look at the mysql table and the $fusion_userid field is blank. 

Any idea how to solve thid? 
proof that an old dog can learn new tricks
Reply
#2

@richb201,

What version of CI are you using? Also, did you check to see what the generated SQL looks like?
Reply
#3

thanks php. I solved this. How? Well, I do about a thousand of trial and error attempts and it just went away. Not the best way to work.
proof that an old dog can learn new tricks
Reply
#4

If you solved it then please write [SOLVED] in your topic title.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply




Theme © iAndrew 2016 - Forum software by © MyBB