$item_type = 30;
$item_type_desc = "side saddles";
?>
include("/home/sites/www.vwsoa.co.uk/web/include/incfunctions.php");
$connection = mysql_connect('localhost', 'sideweb', '87numnahs') or die ("Could not connect to MySQL Server");
$db = mysql_select_db('sidesaddles', $connection) or die ("Could not connect to Side Saddles database");
$sql_query = "SELECT * FROM catelogue WHERE sale_type LIKE 'NEW' AND item_type LIKE '$item_type';";
$sql_result = mysql_query($sql_query) or die ("Could not execute query - $sql_query");
if(mysql_num_rows($sql_result)<1)
{
$item_list[1].= "No $item_type_desc in Database";
}
else
{
$picTemplate = fopen("pictable.php", "r") or die ("Could not open the picture table template file");
$flipper = 1;
while ($row = mysql_fetch_array($sql_result))
{
rewind($picTemplate);
$ID = $row['ID'];
$item_size = $row['item_size'];
$main_desc = $row['main_desc'];
$sub_desc = $row['sub_desc'];
$price = $row['price'];
$picture = $row['picture'];
$item_list[$flipper] .= "
";
if($picture=="")
{
$item_list[$flipper] .= " ";
}
else
{
$item_list[$flipper] .= "";
}
$buffer = "";
while (!feof ($picTemplate))
{
$buffer .= fgets($picTemplate, 4096);
}
$item_list[$flipper] .= emailConvertor($buffer);
if($flipper==1)
{
$flipper = 2;
}
else
{
$flipper = 1;
}
}
fclose ($picTemplate);
}
?>
echo $item_type_desc; ?>
|
 |
|
|
|
|