3
votes
2answers
194 views

Is there a more efficient way of getting a joined result set into a usable array in PHP?

I'm writing a quiz application in PHP and am querying the DB for questions and their associated answers. I then wrangle the resultset into a usable array for my front end. However, it always seems ...
1
vote
1answer
131 views

Extracting Multiple Associative arrays in PHP

public static function find_user_tracks($id) { global $mySQL; $sql = "SELECT * FROM `tracks` WHERE account_id = {$id}"; $result_set = $mySQL->query($sql); $ret = array(); ...