PHP - Statistics?

Hello,

In a MySQL table I have the following rows:
Item name Item price Milk 1.05 Butter 1.50 Lettuce 0.70 Butter 1.55 Bread 0.65 Chicken 3.50 Milk 1.00 Coca Cola 1.20 Apples 0.90 Toothpaste 1.00 Oranges 0.80 Milk 1.00
What I'm looking to do is collect all of the milks, all of the butters, etc and give a $total_price_spent_on value for each product, so for milk we'd have 3.05, for oranges we'd have 0.80, and so on until all items on the list have been totalled.  Then I want to select the most expensive 3 totals, display them in a pie chart, and all other items to be listed under an "other" label.

Any pointers as to how to go about this?

Many thanks

hey guys im trying to make a page statistics, where i get a view count of certian pages users visit. now im after a bit of advise on how the best way to achieve this   here are my tables:

CREATE TABLE IF NOT EXISTS `statistics` (
  
`statistic_id` int(11) NOT NULL AUTO_INCREMENT,
  
`statistic_page_id` int(11) NOT NULL,
  
`user_id` int(11) NOT NULL,
  
`reference_id` int(11) NOT NULL,
  
`ip_address` varchar(15) NOT NULL,
  
`created_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`statistic_id`)
)
 

CREATE TABLE IF NOT EXISTS `statistic_pages` (
  
`statistic_page_id` int(11) NOT NULL AUTO_INCREMENT,
  
`page_name` varchar(90) NOT NULL,
  
`created_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`statistic_page_id`)
) 

what i was thinking is when a user views the page it will check if user has already visited in the database

SELECT user_id 
FROM statistics
WHERE user_id = '1' OR ip_address = INET_ATON('1.1.1.1')
AND statistic_page_id = '1' AND refernce_id = '10'

if user or guest hasnt visited then add to database

INSERT INTO statistics (statistics_page_id, user_id, refernece_id, ip_address, created_timestamp) 
                VALUES ('1', '1' '10', INET_ATON('1.1.1.1'), UTC_TIMESTAMP())

statistics_page_id, would be the id representing a page ie. ITEMS and reference_id would be the id of the ITEM   any advise on a better way on how it should be done would be super...cheers guys

Hey guys. The problem is like that: I have a panel that shows live statistics on a game called Samp , and i used the template  Ace Admin boostrap , and the theme is not showing , the template doesen't work , but i have all the necesary files ,css and all Those are my files: http://i.imgur.com/CF0kebR.jpg
http://i.imgur.com/7quVxHJ.jpg Footer: http://pastebin.com/NAi6EHg4 Header: http://pastebin.com/GmBriy8G  

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=350383.0