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

[Ocean]

Originally Posted by Colin F

Just make a form, make a hidden input called threadid and give it the threadid value and then submit it with the button.
Make another hidden input field named "do" and give it a value like "bumpthread" (at least it sounds like you're making something like this )

In the showthread file, add do if ($_REQUEST['do'] == "bumpthread")
{

}
near the top and just write
$_REQUEST['do'] == "default";

make default the default thing...


[edit] showthread.php doesn't use $do.... oh well, I hope you understand what I mean

I must admit, I'm a bit lost...

In the other thread, you helped me to duplicate the "whoviewed" field in the "thread" table. Well, with this question, I'm trying to figure out how I can put in a link/button in the ShowThread template, that when clicked, will run a SQL Query that will empty the "whoviewedcounter" field of the "thread" table for that particular thread. This way, in addition to knowing who's viewed a particular thread - ever, I can also have a seperate section with a resettable counter.

By doing that, I can reset the counter for a given thread any time I want, and I can see who's viewed it from that point on, in addition to who's viewed it at any point.


Now, there seem to be two parts to making this work:


1. Making a link/button in the ShowThread template, which should be relatively straightforward - I would imagine I could work with an example such as

"<a href="sendmessage.php?$session[sessionurl]do=sendtofriend&amp;t=$threadid">$vbphrase[email_this_page]</a>"

However, I need to know how exactly it should be formatted.


Would I format it like this:

"<a href="showthread.php?do=resetcounter;t=$threadid">$vbphrase[custom_phrase]</a>"


Is the "do=resetcounter" what you were referring to? And is the "t=$threadid" what I need in order to pass along the Thread ID to the script?


2. The portion that gets put into ShowThread.php.

What would I be placing in the ShowThread.php file?

Am I to understand that I need to put this in the beginning:


$_REQUEST['do'] == "default";



And this, somewhere below:


do if ($_REQUEST['do'] == "resetcounter")
{

// ***MySQL Queries go here?***
UPDATE thread SET whoviewedcounter='' WHERE threadid=????

}




I apologize and thank you, in advance. I'm competant, but I don't code in PHP/MySQL. As a result, I can do great things insofar as designing a program is concerned - but I need help with the actual syntax.