Require a quick simple php program to do the following:-
- read a MYSQL table which contains catalog entries of songs and artists
- access Amazon API, find the song in Amazon
- return the Amazon ASID and browse nodes (music genres) which the song appears in.
- work out which is the major browse node (the genre of the song) and update the database with the main genre, other genres and Amazon ASID
If the song is not found, but the artist is, find the browse node (music) which the artist mostly appears in and update the database with the most popular genre for the artist
This should be simple with the Amazon AWIS API for php.
I will supply a mysqdump of the catalog table. It has about 10,000 entries