Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $recipe = "SELECT * FROM recipes
- JOIN recipe_ingredients ON recipes.recipe_id = recipe_ingredients.recipe_id
- JOIN measurement_qty ON recipe_ingredients.measurement_quantity_id = measurement_qty.measurement_qty_id
- JOIN measurement_units ON recipe_ingredients.measurement_id = measurement_units.measurement_id
- JOIN ingredients ON recipe_ingredients.ingredient_id = ingredients.ingredient_id
- ORDER BY section
- ";
- $stmt = $pdo->query($recipe);
- $rows = $stmt->fetchAll(PDO::FETCH_GROUP);
- foreach($rows as $recipe_id=>$recipe)
- {
- $heading = $recipe[0];
- foreach($recipe as $row)
- {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement