Just shoot me is this sounds like jibberish <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Can someone point me in the right direction...
I would like visitors to subscribe and choose 1 catergory of interest.
Then, everytime a new record is uploaded, email everyone a copy of that record who has chosen that
catergory of interest.

Did that make any sense, ha ha probably not must stay off the lager <img src=../images/dmxzone/forum/icon_smile_dead.gif border=0 align=middle>

Any ideas or direction would be appreciated,

Thanks

Hi

What db are you using?
What server-side language are you using?
Can you send emails from your website/application?
Will you or an admin be adding new categories instead of a user?
Do you host the site?


Digga

Sharing Knowledge Saves Valuable Time!!!

Sorry for delay been havin few problems <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Using asp and mysql db,
Strange combination some may say,

Basically registered users will be adding the records, however the catergories are already set up and the uploader chooses the appropriate one for their record.

Should have really put this info in first post <img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>

Cheers

As I see it the trouble is that you need to automate sending the emails, not knowing anything about MySQL databases I dont know if there is a mechanism in there to build a nice looking HTML email and send it when someone adds a new record (which might bog down your server as it would have to wait for all the emails to be sent when someone uploads a new record), other option is to have someone sitting at their PC ready to hit the send button every few hours

However I did something similar in asp with a SQL 2k DB...
If you build your email, recordset included as a vbs then you could use WSH windows scripting host (I'm assuming you're on a windows server given ASP as your scripting language) to schedule the emails, so your subscribed members would get a daily email with relevant records in rather than an email for each record - set it to send at 4am, a nice quite time so your ISP wont complain at you sending thousands of emails at peak time and everyone's happy.


Live the life you love
Love the life you live

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]

That sounds like the way to go, thanks alot

I will look into working it that way, and will probably be back soon for more advice <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Cheers

If you need I can post up the vbs I have - you should be able to adapt that quite easily.
My hosting company were happy to set up the WSH side of things too - I gave them a simple script that points to the vbs (in the root of my site) and they scheduled it at the time i asked for


Live the life you love
Love the life you live

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]