 |
 |
All prices are VAT inclusive.
A tile in a category which is on special is represented in green. ";
$conn=pg_connect("dbname=uctiles user=sqluser password=iadmin");
$sql="select * from products where category=$category order by price";
$result=pg_exec($conn,$sql);
if (pg_numrows($result) > 0)
{
$line=0;
//clear the cache for the file_exists function
clearstatcache();
print " ";
while ($line < pg_numrows($result))
{
$display=pg_fetch_array($result,$line);
$rec=$display[record];
//check if tile has a gallery
$sql="select * from images where tileid=$rec";
$galleryres=pg_exec($conn,$sql);
if (pg_numrows($galleryres) > 0)
{
$gallery="true";
}
else
{
$gallery="false";
}
$grade_id=$display[grade];
if ($grade_id !="")
{
if ($grade_id=="1")
$grade="1st Grade";
if ($grade_id=="2")
$grade="2nd Grade";
if ($grade_id=="3")
$grade="Commercial Grade";
}
else
$grade="";
if ($display[toptile]=="Y")
$fontcolor="green";
else
$fontcolor="black";
$mprice=$display[mprice];
$bname=$display[bname];
$texture=$display[texture];
$finish=$display[finish];
if ($texture==0){$texture="None";}
if ($texture==5){$texture="Rough";}
if ($finish==0){$finish="Matt Finish";}
if ($finish==5){$finish="Shiny Finish";}
//work out the value of the image field using the value of the code
$pos = strpos($display[code]," ");
if ($pos === false)
$image=$display[code];
else
$image=substr($display[code],0,$pos);
$file="/home/httpd/html/u/uctiles/morepics/" . $image . "_1.jpg";
if (file_exists($file))
{
print "";
print "More Pictures";
}
$file="/home/httpd/html/u/uctiles/products/$display[image]";
if (file_exists($file)){$image=" ";}
else{$image="No Image";}
$gallerylink="Picture Gallery";
print " \n\t\n";
// Table inside a table
print "";
// print "| $delete | $modify | $addpic | $gallery | ";
print "";
// Another table inside a table
print "\n";
if ($bname!=""){
print "\t\n\t\t| Brand Name: | \n";
print "\t\t$bname | \n\t \n";
}
else
print "";
print "\t\n\t\t| Name: | \n\t\t$display[name] | \n\t \n";
if ($grade!="")
print "\t\n\t\t| Grade: | \n\t\t$grade | \n\t \n";
else
print "";
print "\t\n\t\t| Texture: | \n\t\t$texture | \n\t \n";
print "\t\n\t\t| Finish: | \n\t\t$finish | \n\t \n";
print "\t\n\t\t| Code: | $display[code] | \n\t \n";
if ($mprice >1)
{
print "\t\n\t\t| Market Price: | \n\t\t";
print "R " . number_format($mprice,2) . " / mē | \n\t \n";
}
else
print "";
print "\t\n\t\t| Our Price: | \n\t\t";
print "R " . number_format($display[price],2) . " / mē | \n\t \n";
print "\t\n\t\t| Size: | \n";
print "\t\t" . nl2br($display[description]) . " | \n";
print "\t \n
\n";
if ($gallery =="true"){ print "\n";}
// End of table inside a table
print " | $image | ";
print " ";
// End of another table inside a table
print " | ";
$line++;
}
print " ";
}
else
{
print "There are currently no $title in the ";
print "database. ";
}
?>
|
