gistfile1.aw

try{
    $dbh->exec("USE isp5;");
    $order = 'song';
    $sth = $dbh->prepare("SELECT * FROM songs ORDER BY $order");
    $sth->execute();
    $result = $sth->fetchAll(PDO::FETCH_ASSOC);

    echo "<form action='' method='POST'>";   
    echo "<table><tr><th><a href=''>Song</a></th><th><a href=''>Artist</a></th><th><a href=''>Votes</a></th><th></th></tr>";
    foreach($result as $r){
        echo "<tr><td>".$r[song]."</td><td>".$r[artist]."</td><td>".$r[votes]."</td>";
        echo "<td><a href='?up='".$r[song]." name=up id=.".$r[song]."'><img src='common/up.png' /></a>";
        echo "<a href='#' name=down id=.".$r[song]."'>
                <img src='common/down.png' /></a></td></tr>";
    }
    echo "</table>";
}