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