Hello, I'm developing a system in which I need a list with all the football teams in the world and their respective championships. I have the following structure in my database:
tb_time (id, name, tb_campeonato_id)
tb_campeonado (id, filiacao, pais, nombre)
I found the site results.com a great base of teams but I'm not sure how I could extract such information from the site. I thought about creating a php script where I could establish the name of the league and the country and then register all the teams from a list that belonged to the proper championship but it would still require a lot of manual effort. What I would like to know is if anyone can suggest me a more automated way of doing this because as I thought it would do a great job to do in each championship and in every country in the world. Thanks in advance.