php - Codeigniter MYSQL Returning Most Recent Row -

i have following code below, , not sure of best way modify shows last entered row database.

the user_date column displayed this: 2010-05-06 12:37:28

controller:

$result = $this->shared_model->getjustjoineduser();     $data['just_joined_user'] = $result->row_array(); 

model:

function getjustjoineduser() {     $query = $this->db->query("select *                               {$this->_table['users']} user                               user_description != '' , user_image != '' , (user_twitter != '' or user_youtube != '' or user_vimeo!= '')                               order user_date desc                               limit 1");      return $query; } 

your query last inserted row restriction in statement.

if want real last row, strip statement this:

$query = $this->db->query("select * {$this->_table['users']} user order user_date desc limit 1"); 

you not seem know sql queries, suggest read tuto it.