jkkenzie Posted September 30, 2014 Share Posted September 30, 2014 Hi, I have an adverts table that has records of currently running adverts, i have not used stored procedures or triggers before. I would like to create a stored procedure or a trigger using phpmyadmin for mysql. Exactly what i want to achieve is, when a record is accessed in adverts table, it causes a table called HITS to create a record that has the adverts_id, IP where the advert was clicked from, current date. Is that possible? Link to comment https://forums.phpfreaks.com/topic/291366-stored-procedure-or-trigger-between-two-tables/ Share on other sites More sharing options...
jkkenzie Posted September 30, 2014 Author Share Posted September 30, 2014 also How is that going to work with PHP? Link to comment https://forums.phpfreaks.com/topic/291366-stored-procedure-or-trigger-between-two-tables/#findComment-1492440 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.