How to query multiple tables with multiple selects MySQL
        Posted  
        
            by 
                brybam
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by brybam
        
        
        
        Published on 2012-03-20T23:20:59Z
        Indexed on 
            2012/03/20
            23:29 UTC
        
        
        Read the original article
        Hit count: 271
        
I'm trying to write a php function that gets all the basic food data(this part works fine in my code)
Then grabs all the ingredients related to the ids of the selected items from the query before.
Anyone have have any idea why my second array keeps coming back as false?
I should be getting 1 array with the list of foods (this works)
Then, the second one should be an array with all the ingredients for all the foods that were previously selected...then in my code im planning to work with the array and sort them with the proper foods based on the ids.
function getFood($start, $limit) {
        $one = mysql_query("SELECT a.id, a.name, a.type, AVG(b.r) AS fra, COUNT(b.id) as tvotes FROM `foods` a LEFT JOIN `foods_ratings` b ON a.id = b.id GROUP BY a.id ORDER BY fra DESC, tvotes DESC LIMIT $start, $limit;");
        $row = mysql_fetch_array($one);
        $qry = "";
        foreach ($row as &$value) {
            $fid = $value['id'];
            $qry = $qry . "SELECT ing, amount FROM foods_ing WHERE fid='$fid';";
        }
        $two = mysql_query($qry);
        return array ($one, $two);
    }
© Stack Overflow or respective owner