hi i am working in a project it is about online ordering of food ..
I have problem in createing the cart.
I have these tables
Member-will have the username and password, member id.
Fooddetails- will have foodid,foodname,fooddescrtion,foodimage,price.
Cartdetails-cart id ,quantity ,price,total,member id,
Orderdetails-order id,total,member id.
cart details has the ordered food details and the total.
orderdetails just has the total and order id .
my problem is the admin should know what are the foods ordered by the users
and the cartdetails should be destroyed as soon the user makes the order ..