I need a newsletter template created that pulls data from my mysql to fill it. I currently have one that was built by a friend but would like it revamp and given a new look. My website uses Joomla with MySQL and the current newsletter template uses php and sql query to fill the newsletter.
I currently have a newsletter located here for review http://www.myjokemail.com/newsletter/news.php
this newsletter pulls from my database to be dynamically created I use this to send my newsletter out. I'm looking for a rework of it.
Here is what I need
1. Sections areas
a. daily blog entry
b. latest 5 pictures section with thumbnails which link back to sites original
c. Recent forum postings section
d. Lastest 5 jokes Title, submitted by, Joke body, Link back to site joke to leave feedback and rate
e. latest 5 videos section with thumbnails which link back to sites original
f. latest 5 links that link back through the site and then to the linking site.
g. latest 5 funny pages section links back to site. Just the page title with a link back to the site for the full articel.
2. Newsletter Template
I would like the template to be simple yet look kinda modern with a fun feel. Colors should be somewhat in line with my main site http://myjokemail.com and contain my logo on the main page.
3. Newsletter sections content
I will need assistance with the SQL quires to fill in the newsletter
4. I would like between some of the sections to have areas for advertising in the newsletter. I currently don't have this setup yet but would like it to be expandable in the future for this.
Does any of this sound like it would change your estimated cost?