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: 166

Filed under:
|

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

Related posts about php

Related posts about mysql