X-Cart forums

[funkydunk]

// this is the vastly complex query 
$query = "SELECT * FROM $sql_tbl[maillist] order by email ASC";

[toonarific]

don't forget the space in

order by

[funkydunk]

edited

[DataViking]

THanks for sharing

[toonarific]

is there also a way to have a running total at the top of the list that shows how many people are subscribed to the newsletter?


one more thing, in the code itself. in the line

{$config.Company.company_website}/mail/unsubscribe.php?email={$subscribers

I had to add the following

{$config.Company.company_website}/xcart/mail/unsubscribe.php?email={$subscribers

since the directory where I keep the cart is xcart, and not directly to the mail folder. just thought Id add that

[groovico]

This thread screams for pointing some people towards marketing manager

Ok we are now officially asking for more suggestions and ideas for extra add on x-cart modules for MM, any ideas/wishes you have please PM or email them to me, we're taking on board loads and many of the good ones will be developed into low cost add ons.

We've already developed and covered most of the wishes/request for x-cart newsletter list control for exports/imports/edit/deletes etc.