I would like to have the real number of homepages instead of Links inside my page:
Example:
I have 100 countries and only one homepage www.google.de; then i put this link one time in every country.
Suddenly i have 100 links at my home.
More complicated:
I have continents like australie, europa,
inside europa i have 20 countries, but again i have only google.com one time in every country.
Again i have 20 links at home and 20 links in europa.
I want to have one link at home, one link for europe and one link for every country.
I just start with this quest and have still no answer how to fix this. Maybe you have an idea for my?
The real problem as an example is:
1. Continents
2. Coutries
3. Cities
To make it more complicated: We have Links in all the levels, but not always.
A link could be in europe, but in no city or in europe and countries but not in a city or only in a city or only in a country and so on. Everything is possible.
Maybe i will try it in php with arrays to get rid of the double counting of links:
select continents
while
select links in an array
select countries
while
select links in an array
select cities
select links in an array
array[catid][linksid] = should be only 1
then sum all arrays with one to the number of links for this cat.
Somewhow like this it should be possible.
Example:
I have 100 countries and only one homepage www.google.de; then i put this link one time in every country.
Suddenly i have 100 links at my home.
More complicated:
I have continents like australie, europa,
inside europa i have 20 countries, but again i have only google.com one time in every country.
Again i have 20 links at home and 20 links in europa.
I want to have one link at home, one link for europe and one link for every country.
I just start with this quest and have still no answer how to fix this. Maybe you have an idea for my?
The real problem as an example is:
1. Continents
2. Coutries
3. Cities
To make it more complicated: We have Links in all the levels, but not always.
A link could be in europe, but in no city or in europe and countries but not in a city or only in a city or only in a country and so on. Everything is possible.
Maybe i will try it in php with arrays to get rid of the double counting of links:
select continents
while
select links in an array
select countries
while
select links in an array
select cities
select links in an array
array[catid][linksid] = should be only 1
then sum all arrays with one to the number of links for this cat.
Somewhow like this it should be possible.