Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- array(
- 'fname' => 'Mark',
- 'lname' => 'Caguioa',
- 'teams' => array(
- 'team' => 'Ginebra',
- 'team' => 'Hotshots'
- )
- )
- $stmt = $this->sql->prepare("
- SELECT
- usr.fname,
- usr.lname,
- (
- SELECT
- team.name
- FROM users usr
- LEFT JOIN teams team
- ON usr.gen_id = team.gen_id
- ) AS to 'teams'
- FROM users usr
- ");
- $stmt->execute(array(':gen_id' => 'generated_id'));
- return $stmt->fetchAll(PDO::FETCH_ASSOC);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement