require_once ("admin/database_connect.php");
$URL = "gallery.php";
if ($cid==""){
$cid="1";
}
/* make connection to database */
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
function GettheFileName($iid)
{
$query = "SELECT imagename FROM images WHERE iid=$iid";
//Print "$query";
$result = MYSQL_QUERY($query);
If ($result) {
$thefilename = mysql_result($result,0,"imagename");
}
else{
$thefilename="";
}
return $thefilename;
}
function DisplayGallery(){
$query = "SELECT cid,image1,image2,image3 FROM categories";
$result = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($result);
$i = 0;
WHILE ($i < $number):
$image1 = mysql_result($result,$i,"image1");
$cid = mysql_result($result,$i,"cid");
Print"

|
";
DisplayImages($cid);
$i++;
ENDWHILE;
}
function DisplayImages($cid){
$query = "SELECT iid,imagename FROM images WHERE cid=$cid ORDER BY iid";
//print "$query";
$result = MYSQL_QUERY($query);
If ($result) {
$number = MYSQL_NUMROWS($result);
$i = 0;
$k=0;
WHILE ($i < $number):
Print"";
WHILE ($k<4):
if ($i<$number) {
$iid = mysql_result($result,$i,"iid");
$imagename = mysql_result($result,$i,"imagename");
Print" ";
Print" | ";
}
else{
Print" | ";
}
$i++;
$k++;
ENDWHILE;
$k=0;
PRINT"
";
ENDWHILE;
}
}
?>
DeMan Construction Corporation :: Construction, Alterations, Renovations, Electrical :: Mississauga, Toronto, Ontario, Canada