Using php/MySQL to run queries on 3+million rows

I have been tasked with creating a web page which queries a table which has 3 million rows. I don't want to print all of the rows, but instead to create a report which lists the top 10 items which appear in the same basket as another item. I have been tasked with creating a web page whi