[Raul7]

Originally Posted by rammieone

Something i have'nt looked at mate but your welcome to have a go and do some testing to get it working on a non vbull page.

here is a the query for anyone intrested, as you see its very basic , you need to add the styling code on top of it, the reason i am not adding mine is everyone page is differing ! btw i am using Event forum, if u r not, take out any reference to lv_vb_eventforums_threadid !

PHP Code:

<?php
require("db.php"); /*this is your DB connection file */
$ctime = time();
$query = "SELECT title , lv_vb_eventforums_threadid, dateline_from FROM  event where dateline_from > '$ctime' ORDER BY dateline_from ASC LIMIT 2;";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

echo "<table width='290'>";

while ($row = mysql_fetch_assoc($result)) {
echo "<tr><td>";

echo "<a href='http://YOURFORUMLINK/showthread.php?".$row['lv_vb_eventforums_threadid']."' target=_blank>".$row['title']."</a>";

echo "<br /><b>On ";
$unixtime = $row['dateline_from'];


$realtime = date("F d", $unixtime + 86400);
echo $realtime."</b>";

echo "<hr></td></tr>";

}

echo "</table>";
mysql_free_result($result);
?>

i aint any advance PHP coder, so excuse my code if its very basic