">
Munro Watercolors - echo $Cat;?>
|
$sqlstr = "SELECT Filename, Category, Title, Dimensions, Owner, Pdate
FROM pics where Category='";
$sqlstr .= $Cat . "' AND PageNum=" ;
$sqlstr .= $Page;
$sqlstr .= " ORDER BY Ordernum";
$result = mysql_query($sqlstr);
?>
$Success=1;
/* LOOP for ALL PIs in theis Category */
while ($Success)
{
$j=0;
while ($row = mysql_fetch_assoc($result))
{
$j++;
if ($j==1 || $j==4)
{?>
}
$tn = $row['Filename'];
$cat = $row['Category'];
$prefix="";
for ($i = 0; $i <= 30; $i++) {
if ($tn[$i] <> ".")
$prefix .= $tn[$i];
else
$i= 31;
}
$tnail="tn_" . $prefix . "_jpg.jpg";
$fulltnail=$row['Category'] . "/" . $tnail;
list ($x, $y, $type, $attr) = getimagesize($fulltnail);
?>

|
if ($j==3)
{?>
} /* End of IF */
} /* End of INNER WHILE */
/* Get next Category*/
if ($j == 0)
{ $Page=1 ;
$sqlstr = "SELECT Filename, Category, Title, Dimensions, Owner, Pdate
FROM pics where Category > '";
$sqlstr .= $Cat . "' AND PageNum=" ;
$sqlstr .= $Page;
$sqlstr .= " ORDER BY Category LIMIT 1;";
$result = mysql_query($sqlstr);
if ($row = mysql_fetch_assoc($result))
{ $cat = $row['Category'];
echo $cat;
$sqlstr = "SELECT Filename, Category, Title, Dimensions, Owner, Pdate
FROM Pics where Category = '";
$sqlstr .= $cat . "' AND PageNum=" ;
$sqlstr .= $Page;
$sqlstr .= " ORDER BY Ordernum";
$result = mysql_query($sqlstr);
echo $sqlstr ;
}
else
$Success=0;
}
else
$Success=0;
} /* End of OUTER WHILE */ ?>
|
|
|
/* close connection */
mysql_close($link);
?>