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
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.
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.
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.