mike

<?php
$query =  mysql_query("SELECT * FROM vouches");
echo "<table><tr><td>Vouch</td><td>Date Posted</td><td>Status</td><td>Username</td><td>Author</td></tr>";

while($row = mysql_fetch_array($query))
{
    echo "<tr><td>";
    echo $row['text'];
    echo "</td><td>";
    echo $row['posted'];
    echo "</td><td>";
    if($row['accepted'] == 0){
        echo "Pending";
    }elseif($row['accepted'] == 1){
        echo "Accepted";
    }
    echo "</td><td>";
    echo GetUsername($row['uid']);
    echo "</td><td>";
    echo GetUsername($row['author']);
    echo "</td></tr>";
}

echo "</table>";

function GetUsername($id){
    $result = mysql_query("SELECT username FROM users WHERE id = '$id';");
    $r = mysql_fetch_array($result);
    return $r['username'];
}

?>