Afternoon,
Purchased links SQL yesterday, and was wondering what the deal was with using a prebuilt sql dump to use to build up the catagories and such.
Basicly, i've spent a fair number of days building up a regions / countys / towns sql dump with id/town/parentid. From what i gather so far from playing around with it and searching around the forum, I would need to restructure the sql dump for towns to be how Links SQL does its thing (in the database) instead of using a seperate table to cross reference the results.
Was wondering if theres anyway around this? considering theres over 2050 towns in one sql dump, each having a parentid to the county they are in etc, and another sql dump table for the regions and again another for the countys, dont fancy rewriting that all over :)
The end result is listing the regions, then listing the counties in that region, then listing the towns in that county, then listing the contents of that town.
Any suggestions / links to where i could figure this out would be appreciated.
Cheers.
Purchased links SQL yesterday, and was wondering what the deal was with using a prebuilt sql dump to use to build up the catagories and such.
Basicly, i've spent a fair number of days building up a regions / countys / towns sql dump with id/town/parentid. From what i gather so far from playing around with it and searching around the forum, I would need to restructure the sql dump for towns to be how Links SQL does its thing (in the database) instead of using a seperate table to cross reference the results.
Was wondering if theres anyway around this? considering theres over 2050 towns in one sql dump, each having a parentid to the county they are in etc, and another sql dump table for the regions and again another for the countys, dont fancy rewriting that all over :)
The end result is listing the regions, then listing the counties in that region, then listing the towns in that county, then listing the contents of that town.
Any suggestions / links to where i could figure this out would be appreciated.
Cheers.