codeigniter - How to sort and put in tables according to customer with php -

DB has been followed in my mysql.

  If not in the table, then `be_users`` ID` int (10) unsigned, not tap AUTACNCRMant, 'username' word (32) voice ... ... 'active' tinnit (1) unsigned Not less than '0', 'Group' int (10) unsigned default faucet, ...); Values ​​(1, `id`,` username`, `password`,` e-mail`, `active`,` group`, 'activation_key`,' last_ visit ',' created ',' modified ')' administrator ' '7209 ... b37', 'admin@gmail.com', 1, 2, zero, '2010-09-26 21:32:46', '2010-07-09 14:16:46', ' 2010-08-03 14:05:31 '), (2,' Anne ',' AA8 ... 48C1 ',' cus7@gmail.com ', 1, 1, faucet,' 2010- 08-02 10:30:42 ',' 2010-07-11 18:12:05, ',' 2010-08-03 13:44:27 '), (3,' tonge ',' 9855 ... B715 BA ',' CUS2 @ Gmail.com ', 1, 1, NULL, NULL,' 2010-07-31 08:20:25, '2010-08-03 13:44:56'),. .. Create a table if not, then 'Be_user_profiles` (`user_id` int (10) unsigned,` company_name` varchar (100) zero zero ... ... PRIMARY KEY ( `user_id`)); Values ​​(1, '', '', '', '', '', '', '', `` _ _ _ _`` `` _ _ _``` `, '', '' ',' ', 0), (2,' Company 1 ',' Anne Soulberg ',' http://www.bla.no ',' test ',' ',' ', 3222) (3,' company 2 ',' tonze ',' http://www.bladesignshop.no/ ',' ',' ',' ', 0), ... make the table, if not, then' omc_projects` (`id` et (10) Null AUTACCRment, `CUTOOR_ID 'AT (10) NOUL,` PROJECT_NAM' (255) NOUL, `TOTAL_ERIT 'NART (10) NOUL,' made '(255) NULL, Primary key (` ID`) ); Price (1, 2, 'Website', 20, 'Shin'), (2, 3, 'Website' `` omc_projects`` (`id`,` cutomer_id`, `project_name`,` total_hr`, `b '),' 20, 'Shin'), (3, 2, 'Logo', 4, 'Shin');  

I want to sort omc_projects according to customer_id like this output.

  & lt; Table & gt; & Lt; TR & gt; & Lt; TD & gt; Company1 & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; Website & lt; / TD & gt; & Lt; TD & gt; 20 & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; Logo & lt; / TD & gt; & Lt; TD & gt; 4 & lt; / TD & gt; & Lt; / TR & gt; & Lt; / Table & gt; & Lt; Table & gt; & Lt; TR & gt; & Lt; TD & gt; Company2 & lt; & Lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; Website & lt; / TD & gt; & Lt; TD & gt; 20 & lt; / TD & gt; & Lt; / TR & gt; & Lt; / Table & gt;  

etc.

I can get user_id and company_name in this way.

  function getAllMemberProfile ($ id = NULL) {$ data = array (); $ This- & gt; Db- & gt; Selection ('user_id, company_name'); $ This- & gt; Db- & gt; ('Be_user_profiles'); $ This- & gt; Db- & gt; Join ('be_users', 'be_users.id = be_user_profiles.user_id'); $ This- & gt; Db- & gt; Where ('be_users.group', $ id); $ Query = $ this- & gt; Db- & gt; get receive (); If ($ query-> num_rows ()> 0) {foreach ($ query-> result_array ($ line as) {$ data [] = $ row;}} $ Query- & gt; Free_Restrel (); $ Data Return;}  

But I'm not sure how to get all the projects and put them in tables according to customers.

Any help

> Thanks in advance.

Try it once:

  $ this -> order_by ('be_users.id'); // $ $ after this-> db-> where (' Be_users.group ', $ id );