Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. id status
  2. 199 1
  3. 142 0
  4.  
  5. user_id hours seconds
  6. 199 10 90
  7. 144 0 800
  8.  
  9. $results = array();
  10. $results = $this->db->query
  11. ("SELECT user.id,user.status,records.hours,records.seconds from user INNER JOIN records ON user.id = records.user_id WHERE user.status = 1 and records.hours or records.seconds > 0 ");
  12. $get_results = $results->result_array();
  13. return $get_results;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement