so i need to create a shopping list application that allows a user to create a list, populate it with categories (frozen food, fruit, electrical etc) and then populate categories with items (burgers, apples, DVD's) they need to be able to add, edit and delete lists, items and categories aswell as be able to order them individually (for example move frozen category up or down the list to any position...same for items in categories).
so i created a database...i have 3 tables:
List table (listid, listname, listorder)
Category table (catid, listid, catname, catorder)
item table (itemid, catid, itemname, itemorder)
i got it to create, edit and delete lists...but when i view a list to see the categories and items in that list i cant get it to display properly.
i used this code:
Code: Select all
$sql=mysql_query("SELECT items.itemname, cat.category FROM items,cat WHERE cat.catid=items.catid");
while($res=mysql_fetch_array($sql))
{
echo $res['category'] . "<br>";
echo $res['itemname'] . "<br>";
}
frozen
chips
frozen
burgers
fruit & veg
apples
fruit & veg
potatoes
what i need is for it to display the category name only once...then each item under that correct category..then display the next category and its respected items etc etc.
that is my main problem..the only other thing i would like to ask is how do i order things? and i dont just mean ascending or descending..i mean individual items...someone told me to create an order field in each table..but i dont know what to do with them.
please help anybody?
im not great with PHP any examples would be greatly appreciated as terminology goes straight over my head
thanks in advance