How do I add a button/link that runs SQL Queries?

[Ocean]

Hi! I need some help with this...


I would like to add either a button or a link to the ShowThread Template.


However, when that button or link is clicked, I want it to run a number of SQL Queries and then refresh the page.


Can someone help me figure out how this needs to be structured? I assume that the link in the ShowThread template will have to call a PHP file, although I don't know if it needs to be a seperate file, or if the addition should just be made to ShowThread.php.

I'm also uncertain as to the formatting of code that needs to be done.


To give us something to work with, the first query it's going to need to run will be to empty a field within that Thread's record in the "thread" table. For example:

UPDATE thread SET field1='' WHERE threadid='12345'

I imagine that we have to somehow pass the Thread ID along to the script, and format the SQL Query to take that variable into account.


Can someone help enlighten me as to how this all needs to be done?

Thanks!