MetaPhaze products.p

<html>

<head>

<link rel="stylesheet" type="text/css"
href="css/mystrix.css" >

<title>

</title>

</head>

<body>

<div id="header"><img src="png/mystrix33d.png" width=800 /></div>
<div id="container">

<div id="left">
</div>
<div id="content"
<?php
include 'header.php';

if (is_numeric($_GET['category']))
$catnum = $_GET['category'];

$sql_string = "SELECT item_t.itemname AS item_name, item_t.itemid AS item_id, item_t.itemprice AS item_price, cat.catname AS cat_name
FROM items AS item_t, category AS cat
WHERE item_t.itemcat = catnum
AND item_t.itemcat = ".$catnum."";

$res = query($sql_string);

$item_list = "<table border='1' cellpadding='5'>\n";

while ($data = mysql_fetch_assoc($res))
{
$item_list .= '<TD>$'.$data['item_price'].'</TD><TD>'.$data['item_name'].'</td><td> ('.$data['item_id'].")</td><tr>";
$cat_name = $data['cat_name'];
}

$item_list .= "</table>";
echo "<h1>$cat_name</h1>\n$item_list";

include 'footer.php';
?>


</div>
<div id="right">
</div>
<div id="footer">
This site powered by<br> <img src="png/gentoo.png">
</div>
</body>

</html>