rendered paste body<?php
include "../inc/connect.php";
$id = $_GET["id"];
$aliases = $row["aliases"];
$sql = "SELECT * FROM `series` WHERE artist='$aliases' ORDER BY title ASC";
$result = mysql_query($sql);
if ( !$result ) {
// replace this with your own error code -- one that doesn't display the query
die($query.'<br />'.mysql_error());
}
echo "<table border='0' width='100%' id='table1'><tr>";
// Build Table
while( $row = mysql_fetch_assoc( $result ) ) {
$i++;
echo '<td width="33%" valign="top" height="65">';
echo '<a href="/v2/series/view.php?id=' . $row['id'] . '" target="_blank"><img border="0" src="/v2/series/images/thumbs/' . $row['category'] . '/' . $row['id'] . '.jpg"></img></a><br />Title: <a href="/v2/series/view.php?id=' . $row['id'] . '">'.$row['title'].'</a><br /></a>Series: <a href="/v2/series/?p=' . $row['category'] . '">'.$row['cat2'].'</a><br />Artist(s): '.$row['artist'];
echo '<br /></td>';
if ( $i == 2 ) {
echo '</tr><tr>';
$i = NULL;
}
}
echo '</tr></table>';
?>