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? Quote 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? Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.