parse html tables and match against db

[Anon]

hi all
hope someone can help with this...
i want to strip a html page and grab the rows from the table and put them into an array. once they are in an array i want to match the second column of the table against a mysql db and match records.
so i want to go to
http://www.pgatour.com/scoring/pgatour/
and get the table of scores but i only want to pull out the rows of the australian players and put theeir scores into a db.
so i already have a mysql db of all the aussie players and then i want to do an fopen across the above link and pull out the rows of the table where the names match and grab the scores and other info from that row...

so if greg norman was at row 3 and the table is being parsed and the second column contained greg norman on the scoreboard then there would be a match and all the info from that row would be thrown into the db...of course it would rely on the fact that the names are spelt correctly and that no 2 people have the same name...

hope that all makes sense....basically i just need a way of grabbing only the australian scores from the whole list.

thanks for any help you can give me...

jason

[Anon]

don't store the table in html... rather have a database table that stores what players you want, and then query to scores as you go and build the table

[Anon]

hi michael
thanks fore the reply but i think you have missed what i am saying.
i have a db of the players i want to query already..what i am saying is that i have to suck down that PGA Tour page and somehow throw each table row into an array and then match the name of the player from the row and throw it away if it doesn't match what is in the db (eg not australia player)

so i need to know how i can match an array that is sucked live from a html page against a mysql db.

thanks mate
jason