result() To fetch multiple records from the database table we need to use result().
row()To fetch a single record from the database table we need to use row().
Example:
$query = $this->db->query("YOUR QUERY");
$data=$query->result();
foreach ($data as $row) {
echo $row['title'];
echo $row['name'];
echo $row['body'];
}
row()
$query = $this->db->query("YOUR QUERY");
if ($query->num_rows() > 0) {
$row = $query->row_array();
echo $row['title'];
echo $row['name'];
echo $row['body'];
