Page 1 of 1

Display MySQL results in Newsletter

PostPosted: 5:03pm, Thu 13 Nov, 2014
by coderdj412
Can PhpList display results from a MySQL query in a newsletter?

For example, I wanted to let people know what the top 10 most visited pages on my website were via a MySQL query.

Re: Display MySQL results in Newsletter

PostPosted: 9:03pm, Fri 14 Nov, 2014
by duncanc
phplist doesn't help you with this. Two solutions are
  • develop a web page that shows the required email content and then use "send web page" when composing a campaign.
  • develop a plugin for phplist that replaces a placeholder, such as [TOP10] by the chunk of html that shows the top 10 pages. Then include the placeholder in your campaign.