Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. array(
  2. 'fname' => 'Mark',
  3. 'lname' => 'Caguioa',
  4. 'teams' => array(
  5. 'team' => 'Ginebra',
  6. 'team' => 'Hotshots'
  7. )
  8. )
  9.  
  10. $stmt = $this->sql->prepare("
  11. SELECT
  12. usr.fname,
  13. usr.lname,
  14. (
  15. SELECT
  16. team.name
  17. FROM users usr
  18. LEFT JOIN teams team
  19. ON usr.gen_id = team.gen_id
  20. ) AS to 'teams'
  21. FROM users usr
  22. ");
  23. $stmt->execute(array(':gen_id' => 'generated_id'));
  24. return $stmt->fetchAll(PDO::FETCH_ASSOC);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement