[Overgrow]

I started with PERL and went to PHP after a year or so (same reason, UBB to VB). It's SO MUCH NICER when programming for the web. Get into it, you won't regret it. I'll break this down a bit for you..

$startToday?=?strtotime(date("m/d/y",time()));

strtotime is a built in PHP function, if you ever wonder if something is built in and what it does, go to

www.php.net/strtotime

or whatever the function name is, and you will get the info.


date is also a built in php function, as well as time...

Bascially I'm pulling the current timestamp with time(), formatting it with date, and then translating that BACK into a timestamp with strtotime. The key there is that when I do the first conversion, I don't use the hour:minutes so eventually it returns the timestamp of TODAY at 12:01 AM.

After that, I add 86400 seconds to it to make the endToday timestamp = tomorrow.

Then I build the SQL query.. After you finish writing the query, do something like

PHP Code:

$results = mysql_query($query,$db_connection);

while ( $row = mysql_fetch_array ( $results ) ) {

print "<a href=\"showthread.php?threadid=$row[threadid]\">$row[title]</a>";

}