Show posts on main page

[JacBowen]

Hey Guys,

I have changed the thread as I have got somewhere .
Ok here is the code now:

PHP Code:

<style type="text/css">
<!--
.style1 {
    font-size: 10px;
    font-weight: bold;
    font-family: Verdana, Arial, Helvetica, sans-serif;
}
.style2 {
    font-size: 10px;
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-style: italic;
}

-->
</style>
<span class="style1">
<?
include("db.php");
$query = mysql_query("SELECT * FROM $mysql_table");
$query = mysql_query("SELECT * FROM `$mysql_table`
ORDER BY `postid` DESC
LIMIT 0 , 25");
if(mysql_error()) {
print(mysql_error());
}
while($row = mysql_fetch_array($query)) {


echo "

".$row['title']." -
".$row['username']."
<p>
";
}
?>
</span>









<span class="style2">
<?
include("db.php");
$query = mysql_query("SELECT * FROM $mysql_table");
$query = mysql_query("SELECT * FROM `$mysql_table`
ORDER BY `postid` DESC
LIMIT 0 , 25");
if(mysql_error()) {
print(mysql_error());
}
while($row = mysql_fetch_array($query)) {


echo "

".$row['pagetext']."
<p>
";
}
?>
</span>

It's looking good, but it could do with a clear up and maybe a expert telling me what it's like.

All I need is for the 'threadtitle' to be linked to the actual thread (I know how to do this but the html hyperlinking wont seem to work properly).

And I need the dateline to show up to, but it only comes up in codes.
If anyone could help.

This is what I want it to look like:

PHP Code:

<?
<a href="http://www.????.co.uk/vBulletin/showthread.php?t=.$row['threadid']."">".$row['title']."</a>
?>