Possibly bug or incorrect code?

First of all, it's not good practice to put database actions inside a view.

I accept this fact that putting database actions inside a view is bad, but i've tried in model and then i was investigating the issue, but the same as i was having experience in the model.

I will try this and will see.

You could also try using var_dump(); on the query result.