Jump to content

Archived

This topic is now archived and is closed to further replies.

hadem

Grouping Like Items

Recommended Posts

So i wanted to write a simple PHP script that would keep track of my recipes in a MySQL database so that I could keep track of the ingredients, any notes, and ratings, etc. I really wanted a feature where i could select a bunch of recipes and have the script generate a shopping list for me. I know how to do that, but then i want it to group like items. So, if two different recipes call for one apple, the shopping list would tell me to buy 2 apples instead of listing 1 apple twice. Does anyone have any suggestions? Thanks in advance.

Share this post


Link to post
Share on other sites
you could probably use "GROUP BY" in your query.

SELECT * FROM recipies WHERE cluause goes here GROUP BY ingrediantsTable

OR

in your PHP script that makes a list, as you go through your database results and add each item to the list, put them into an array. As you add each item to the array, do a check to see if the item is already inarray(). if so, don't add it again.

Share this post


Link to post
Share on other sites
So i got it to group. i used

[code]$result = mysql_query("SELECT item, SUM(qty) FROM recipes GROUP BY item");[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.