I am building a website for a golf pool for me and a few buddies. I want to access live data from PGAtour.com. Specifically, I want to get the dynamic table titled "Full Leaderboard" from this URL: http://www.pgatour.com/r/leaderboard/
I used FireBug to try endless permutations on "Copy XPath," but I never get any data.
For instance, here is a query that returns some very pretty stuff, but no data:
select * from html where url="http://www.pgatour.com/r/leaderboard/" and xpath='//*[@id="tourLbPlayersDiv"]'
The query you give above works as intended - but cannot retrieve the player data because it is not contained in the page. Either find a page that has the data, or find some API that provides this data.