0

Hi,

Basically what im looking to implement is a function where a user performs a search on my site, and is presented with the results and an option to be emailed similar items in future.

I have all the search stuff done, but have no idea where to start on the email me similar items in future part.

Any help much appreciated

2
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by baki100
0

i don't think MySql has built in email functions like Oracle's PL/SQL so instead you will have to do it from the front-end system which i assume is php.

0

i don't think MySql has built in email functions like Oracle's PL/SQL so instead you will have to do it from the front-end system which i assume is php.

no i realise that i cant perform this via mysql, im more looking for advice on how to approach it, not looking for code necessarily.

i assume it will involve cron, php and mysql of course, im just boggled by how to implement it.

0

so first you will have a user table that links to a favourite_table that has the user id and a product category id that links to a product_category table in this table you a product category id and the category description (games, software, hardware, peripherals). so when a user visits those pages more than 5 times (or whatever amount) insert the product_category id and the user id the in the favourite_table, so every month you can run the cron and link all the new products and product category id for that user and email him/her a catalogue of the new products, here some stuff i found on the net about email function in php (i don't know php):
http://email.about.com/cs/phpemailtips/qt/et031202.htm
http://www.smartwebby.com/PHP/emailsending.asp

research some stuff on email servers

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.