Need help with database coding...

I am trying to put a "last post" feature on the index page of my website. I found this code on the site, but it doesn't seem to be working properly, as it just shows a random post from a random forum. Any ideas on how to fix the problem?

(The stars are filled in with my correct database info)

Here's the code:

<?php
$servername= "***";
$dbusername = "***";
$dbpassword ="***";
$dbname= "***";
$forumlocation= "***";

mysql_connect("***", "***", "***") or die("Couldnt find MYSQL!");
mysql_select_db("***") or die ("Couldnt find DB!");

$cekilen_mesleki=mysql_query("
select threadid, title, postusername, postuserid, dateline, forumid
from thread WHERE
visible= '1' AND (forumid='5' OR forumid='7' OR forumid='6' OR forumid='8' OR forumid='20' OR forumid='10' OR forumid='11' OR forumid='12' OR forumid='13' OR forumid='14' OR forumid='15' OR forumid='30' OR forumid='31' OR forumid='23' OR forumid='29' OR forumid='24' OR forumid='22' )
order by dateline ASC LIMIT 1
");

if (mysql_error()) {echo "mySQL error:"; echo mysql_error(); exit;}
$mesleki_number=mysql_numrows($cekilen_mesleki); //number of news fetched
if ($mesleki_number<=0) {echo "<tr><td bgcolor=\"#FFFFFF\">No New Message!</td></tr>";}//no news on database!
else {
$ii=1;
while ($gelen= mysql_fetch_row($cekilen_mesleki))
{
if ($ii % 2) {$tdcolor="#FFFFFF";} else {$tdcolor="#eeeeee";}
echo '<td><td bgcolor="'.$tdcolor.'"><font size=1 face=verdana><a href="'.$forumlocation.'showthread.php?s=&threadid ='.$gelen[0].'">'.$gelen[1]."</a><br>Last forum post by: <i>".$gelen[2]."</i> ";

echo "</td></tr>";
$ii++;
}

} //else kapa parantez
?>

Or is there another hack that is better? I have seen a hack for this in a large collection of hacks, but never as a single hack.

Thanks for any help!

[thuffner]

That only shows the M-D-Y again. Is there any way to get the clock time? Like 12:43 PM?

How would I incorporate vb date in there?

Thanks.