I am going to be building approximately ten websites that will each promote a separate market segment for my mortgage brokerage. For example, I will have one website for first time homebuyers, another website for mortgages for people with bad credit, another for hard money loans, etc.
Each of the websites will have between 200 and 2,500 separate mortgage related articles. In total, there will be as many as 25,000 articles between the websites. I want each of the articles to link to several other articles on the other websites at random.
To do this, I want to maintain a single database of all of the urls to the articles on all of the websites. It would be impossible for me to maintain identical databases of that size on each of the ten websites.
I want to have the links displayed on the webpage like this:
link 1 | link 2 | link 3 | link 4
I also want to be able to change the number of links to display. That way I can choose later on how many links to display and change it if I want.
In addition to having the links generated at random, I want the text for the links to be generated at random. Each url in the database will have 5 or so different versions of the link text, and I want the text for the link to be chosen at random from those five options. If a certain URL has only one version of the link text, it should default to that. If there is more than one version, it should choose at random from those that are available.
Because I will be adding large numbers of urls to the database at different intervals, I want to have some sort of batch import. Ideally, I will have the links first in a text file database that I can edit, and then the information from that database will import into the mysql database. One way to do this would be to have a form on the website that allows for me to enter the content of the text file (with the fields separated by "|"), so that the script can automatically add that information to the database.
One thing is certain - I cannot enter the urls into the database one at a time. There will be too many for that to work well.
I am relatively open about how this works. As long as the end result is the same, I don't care about the method of making this work. If you have ideas I am willing to listeto them.