• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to get values from single coloumn


I have a table for personal data, which contains contents such as name, address, gender, etc.
now I want to calculate the total male or female from the gender column, so I make a sql query like this:

SELECT gender, COUNT(*) AS total
FROM personaldata
GROUP BY gender

the result is :

Quote:man : 3
woman : 6

So, how do I write the code on the model and controller and display it on my website?
this is my code so far:

PHP Code:
   public function total_gender()
       $this->db->select('gender, count(*) as total');

       $query $this->db->get()->row()->total;
       return $query->result();

Thank you and sorry for my bad english   Angel


Maybe these links will help:
https://codeigniter.com/user_guide/general/views.html (simply replace the array with the results from a model method)


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.