What I want to do is upload a CSV file containing business owner details:
business name
business owner name
address
phone
fax
suburb
state
country
category of business (eg, hairdresser, shop, etc)
save this data into a mysql database. Also save the date it was added.
Each row of data gets converted into a business listing on a web page.
So each business gets its own web page (1 page per business)
Eg:
put business name, suburb, phone into title tag
<title>Business Name Suburb Phone</title>
<h1>Business Name</h1>
<p>address</p>
<p>phone</p>
etc
Wrap a header and footer around it (I supply a [login to view URL] and [login to view URL] file - you just have to add an include call at top and bottom of your page).
save the web page on my server.
Make a page with a list of links to all those new business pages. Each link contains the business name, suburb and phone number in the anchor text, and the url leads to the page which contains that business name, suburb, phone... etc.
eg,
<a href="[login to view URL]">Business Name Suburb Phone</a>
<a href="[login to view URL]">Business Name2 Suburb2 Phone2</a>
etc
After the script has done all that, I need it to add a link on my "Business Directory" page. This link will point to the page with the list of links.
Please make the script add the new link at the top of the page (above the old existing links, and below the header and menu on the page). Anchor text will be the date it was added (eg 2011-01-06).
Eg:
<a href="[login to view URL]">2011-01-06</a>
<a href="[login to view URL]">2010-12-15</a>
<a href="[login to view URL]">2010-11-29</a>