Kohana V3 return query result as object?

I think the following would give you all results: $user = DB::select('*')->from("users")->where('username', '=', $username)->as_object()->execute() Whereas the following here, would give you the first item: $user = DB::select('*')->from("users")->where('username', '=', $username)->as_object()->execute()->current() Try: KO3 Database Wiki.

I think the following would give you all results: $user = DB::select('*')->from("users")->where('username', '=', $username)->as_object()->execute(); Whereas the following here, would give you the first item: $user = DB::select('*')->from("users")->where('username', '=', $username)->as_object()->execute()->current(); Try: KO3 Database Wiki.

Thanks for reply. But unfortunately when trying to access echo $user->password; throws error ErrorException Notice : Undefined property: Database_MySQL_Result::$password – Asif Mar 30 '10 at 5:28 Which method did you use? Apologies for late reply.

– Craig Apr 3 '10 at 10:34 I tried with the syntax given above and tried to fetch $user->password, that time this error appears. – Asif Apr 6 '10 at 9:48 Have you tried using the second query I provided? It uses the method current(); and returns a usable object.

I was able to echo $user->password; without any issues. – Craig Apr 8 '10 at 11:18.

You just need to add a ->current() to the end of your query: $user = DB::select('*')->from("users")->where('username', '=', $username)->execute()->current().

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.