Return query results and number of rows
Development and Programming
12 years ago
Hi;
What is the best way to return query results and number of rows? I do this but I dont really like it
public function list_messages($id)
{
$this->db->select('message.content,
message.clicked,
message.title,
message.date_added,
message.time_added ');
$this->db->from('message');
$this->db->where('receiver_ID', $id);
$query = $this->db->get();
$results[] = $query->result();
$results['rows'] = $query->num_rows();
return $results;
}
12 years ago
return $query then
12 years ago
return $query then
Sweet like apple juice
12 years ago
return $query then
But this doesnt work:
$query = $this->db->get();Doesnt return results!
$sql = "SELECT ...WHERE ad_have.member_ID = ? AND ad_have.id = ?";
$query = $this->db->query($sql, $details);
print_r($query);
//printsCI_DB_mysql_result Object
(
[conn_id] => Resource id #29
[result_id] => Resource id #36
[result_array] => Array
(
)
[result_object] => Array
(
)
[custom_result_object] => Array
(
)
[current_row] => 0
[num_rows] => 1
[row_data] =>
)
12 years ago
Simple and effective!