compulsionlc Posted November 13, 2008 Share Posted November 13, 2008 I have created a classifieds ad site which also has a subscriptions based service where members can subscribe to ad categories. I am no php guru but do know some mysql. What recommendations do you have for automating sending out the emails to members daily with a report or a link to the ads that have been added for that day. currently i have 32 ad categories so i need to make at least some part of this process automated. Link to comment https://forums.phpfreaks.com/topic/132501-subscriptions-and-emails/ Share on other sites More sharing options...
Aonxe Posted November 13, 2008 Share Posted November 13, 2008 Maybe write a script that does it and have a cron job run the script at a certain time of the day. Link to comment https://forums.phpfreaks.com/topic/132501-subscriptions-and-emails/#findComment-688998 Share on other sites More sharing options...
haku Posted November 13, 2008 Share Posted November 13, 2008 Do it one step at a time - you have asked more than can be addressed in one thread. First start out with what the poster above me said - figure out how to get a cron job running periodically so it sends out mails. Then come back with the other half of your question. Link to comment https://forums.phpfreaks.com/topic/132501-subscriptions-and-emails/#findComment-689026 Share on other sites More sharing options...
compulsionlc Posted November 13, 2008 Author Share Posted November 13, 2008 Thank you and that is a good idea. However i would like to start with knowing how to populate html pages and then email the page. However in the interim i would be interested in knowing how i can possibly send out multiple emails with dynamic data pulled form a myswl database. Eg. i have a table calls subs subid (id for each subscription) catid (the category id for the ad subscribed to) email (the email address to send the mail to) i was thinking of just as a matter of urgency for now, include a link in the email pointing to a page with the necessary information but the page has to be dynamic and most likely pull information from several url variables. eg. www.mydomain.com/ads.php?catid=7&date=20081005 however this information has to be different for each user based on the matching column in the database. so i would need to print the catid variable and the date variable and append it to the url for each user based on thier preferences. Please help. Link to comment https://forums.phpfreaks.com/topic/132501-subscriptions-and-emails/#findComment-689050 Share on other sites More sharing options...
nitation Posted November 13, 2008 Share Posted November 13, 2008 Too many stuff to fix for you at the same time. Learning how to output an HTML page and sending multiple emails and so forth. I would suggest to make your question direct else, your question would have no attention. My 2 cent Link to comment https://forums.phpfreaks.com/topic/132501-subscriptions-and-emails/#findComment-689160 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.