Untitled

<html>
<head></head>
<body>
<?php
$username="totally_bob";
$password="bob1";
$database="totally_catalogue";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");


if ($_GET){
	if($_GET['product_id'} {
	$result = mysql_query("SELECT * FROM products2 WHERE product_id = '" . $_GET['product_id'] . "'");
}
else if ($_GET['start']) {
$start=$_GET['start'];// To take care global variable if OFF
if(strlen($start) > 0 and !is_numeric($start)){
echo "Data Error";
exit;
}
$eu = ($start - 0);
$limit = 50; // No of records to be shown per page.
$dis = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;
$query2=" SELECT * FROM products2 ";
$result2=mysql_query($query2);
echo mysql_error();
$nume=mysql_num_rows($result2);

$result = mysql_query("SELECT * FROM products2 limit $eu, $limit ");
}
	while($row = mysql_fetch_array($result)) {
		$first=$row["product_artist2"];
		$last=$row["product_artist"];
		$title=$row["product_title"];
		$format=$row["product_format"];
		$label=$row["product_label"];
		$mono=$row["product_monostereo"];
		$condition=$row["product_condition"];
		$special=$row["product_special"];
		$origin=$row["product_origin"];
		$price=$row["product_price"];
		$offer=$row["product_offer"];
		$comment=$row["product_comment"];
		$picture=$row["product_picture"];
		$id=$row["product_id"];


?>
<center>
<table border="1" cellpadding="3" style="float:left;">
	<tr>
		<td>Artist:</td>
		<td><?=$first . $last;?></td>
	  </tr>
	  <tr>
		<td>Title:</td>
		<td><?=$title;?></td>
	  </tr>
	  <tr>
		<td>Format:</td>
		<td><?=$format;?></td>
	  </tr>
	  <tr>
		<td>Label:</td>
		<td><?=$label;?></td>
	  </tr>
	  <tr>
		<td>Mode:</td>
		<td><?=$mono;?></td>
	  </tr>
	  <tr>
		<td>Condition:</td>
		<td><?=$condition;?></td>
	  </tr>
	  <tr>
		<td>Origin</td>
		<td><?=$origin;?></td>
	  </tr>
	  <tr>
		<td>Special Info</td>
		<td><?=$special;?></td>
	  </tr>
	  <tr>
		<td>Comments:</td>
		<td><?=$comment;?></td>
	  </tr>
	  <tr>
		<td>Price/Offer:</td>
		<td>Fixed price: <?=$price;?><br/>
		Current Offer:<?=$offer;?></td>
	  </tr></table>
	<table style="float: left;" border="1" cellpadding="0">
		<tr><td><a href="images/<?php echo $picture ; ?>"><img src="images/<?= $picture; ?>" width="650" height="400"></a></td></tr>
	</table>
</center>
<?php

}

}

?>
<b><center>Current List (updated 06/08/10 14.10) - Click for pictures (some aren't uploaded yet - please enquire)</center></b><br><br>
<center>To make an offer for an item or if you have any questions, <a href="mailto:enquiries@totallyvinyl.com">please email us enquiries at totallyvinyl.com</a>
<b><i><center><font color"red">Note - May take a while to load depending on your internet connection.</font></i></b></center>
<table border="1"  cellpadding="2">
	<tr>
		<th><font face="Arial, Helvetica, sans-serif">Info</font></th>
		<th><font face="Arial, Helvetica, sans-serif">Artist</font></th>
		<th><font face="Arial, Helvetica, sans-serif">Title</font></th>
		<th><font face="Arial, Helvetica, sans-serif">Format</font></th>
		<th><font face="Arial, Helvetica, sans-serif">Label/CatNo.</font></th>
		<th><font face="Arial, Helvetica, sans-serif">Mode</font></th>
		<th><font face="Arial, Helvetica, sans-serif">Condition (Cvr/Disc)</font></th>
		<th><font face="Arial, Helvetica, sans-serif">Special</font></th>
		<th><font face="Arial, Helvetica, sans-serif">Origin</font></th>
		<th><font face="Arial, Helvetica, sans-serif">Price</font></th>
		<th><font face="Arial, Helvetica, sans-seri\">Current Offer</font></th>
	</tr>

<?php
while($row = mysql_fetch_array($result)) {
	$first=$row["product_artist2"];
	$last=$row["product_artist"];
	$title=$row["product_title"];
	$format=$row["product_format"];
	$label=$row["product_label"];
	//$catno=$row["product_catno"];
	$mono=$row["product_monostereo"];
	$condition=$row["product_condition"];
	$special=$row["product_special"];
	$origin=$row["product_origin"];
	$price=$row["product_price"];
	$offer=$row["product_offer"];
	$comment=$row["product_comment"];
	$picture=$row["product_picture"];
	$id=$row["product_id"];
?>


<tr>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><a href="display.php?product_id=<?=$id;?>">More info</a></font></td>
	<td><font size=2 face="Arial, Helvetica, sans-serif"><?=$first;?> <?=$last;?></font></td>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><?=$title;?></font></td>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><?=$format;?></font></td>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><?=$label;?></font></td>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><?=$mono;?></font></td>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><?=$condition;?></font></td>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><?=$special;?></font></td>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><?=$origin;?></font></td>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><?=$price;?></font></td>
	<td><font size=1 face="Arial, Helvetica, sans-serif"><?=$offer;?></font></td>
</tr>
<?php
}
echo "<table align = 'center' width='50%'><tr><td align='left' width='30%'>";
if($back >=0) {
print "<a href='$page_name?start=$back'><font face='Verdana' size='2'>PREV</font></a>";
}

echo "</td><td align=center width='30%'>";
$n=0;
$n=1;
for($n=0;$n < $nume;$n=$n+$limit){
if($n <> $eu){
echo " <a href='$page_name?start=$n'><font face='Verdana' size='2'>$l</font></a> ";
}
else { echo "<font face='Verdana' size='4' color=red>$l</font>";} /// Current page is not displayed as link and given font color red
$l=$l+1;
}
echo "</td><td align='right' width='30%'>";
if($dis < $nume) {
print "<a href='$page_name?start=$next'><font face='Verdana' size='2'>NEXT</font></a>";}
echo "</td></tr></table>";


}
?>

</table>
</body>
</html>