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){
	$result = mysql_query("SELECT * FROM products2 WHERE product_id = '" . $_GET['product_id'] . "'");
	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"];
?>
<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;" images="" dacksub.jpg="" 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

}

}

else {

$result = mysql_query("SELECT * FROM products2");

?>
<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="3">
	<tr>
		<th><font face="Arial, Helvetica, sans-serif">Picture</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>
		<th><font face="Arial, Helvetica, sans-serif">Product Comment</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=1 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
}
}
?>

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