As promised I'm back again the second and should be the last part for the iTunes stats with PHP & MySQL. In the previous section I covered how to get your iTunes information from iTunes into a MySQL database. Since I didn't get any questions about it I can either assume that no one cares or no one had any troubles.
This part is not exclusive to a Mac, you can write your PHP scripts with any operating system that you want. So if you're not on a Mac but has a friend who does then you can send your friend your iTunes XML file and your friend can export the data for you. Let’s get stated shall we.
Since in the first part of the series, he showed how to put information into the database, he shows in this second part how to get things back out. There's code samples for connecting to the database, the SQL to grab all of the data out from the table and echo out the information inside. He also links to his stats as an example.