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

[Ocean]

Originally Posted by Colin F

oh of course

<snip>

That should do it.

Ah! Well, now the date is showing up in the correct format - there are only two problems remaining:


1. The date is showing up as 12-31-1969 (which is obviously not the correct date).

2. The time is missing.


<sheepish>

[Colin F]

for 2. change $vboptions[dateformat] to any time/dateformat you like.
See http://www.php.net/date for reference and be sure to enclose it with "'s

for 1. have a look in your database and tell me what value is saved in the whoviewedreset field of the thread you are trying this on.

[Ocean]

Originally Posted by Colin F

for 2. change $vboptions[dateformat] to any time/dateformat you like.
See http://www.php.net/date for reference and be sure to enclose it with "'s

Done. I originally made a mistake with the syntax, but I figured out what I did wrong, and now the format is fine.

I'm now getting:


12/31/1969 - 07:00 pm

Originally Posted by Colin F

for 1. have a look in your database and tell me what value is saved in the whoviewedreset field of the thread you are trying this on.

"1092748098"


When I reset the counter, the database value does change. After I read off the above value, I reset the counters again, and it changed to "1092748229". However, the date and time shown is exactly the same.


Edit:

Aha! Solved! The problem was that I had to change this:


$whoviewedreset = vbdate("m/d/Y - h:i a", '$thread[whoviewedreset]');

to this:

$whoviewedreset = vbdate("m/d/Y - h:i a", $thread[whoviewedreset]);


The ' characters around the $thread[whoviewedreset] variable was invalidating the value and returning zero.


So, now everything is working perfectly!



I can't thank you enough, Colin. I really appreciate all the time you put into this. And again, I apologize for making you do so much coding.