All pastes #67943 Raw Edit

Unnamed

public text v1 · immutable
#67943 ·published 2006-06-20 20:27 UTC
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>';
?>