0)
$substrateTypeSQL .= ” AND manufacturerREF = “.$manufacturerREF;
if (intval($textureREF) > 0)
$substrateTypeSQL .= ” AND textureREF = “.$textureREF;
if (intval($blendREF) > 0)
$substrateTypeSQL .= ” AND blendREF = “.$blendREF;
$substrateTypeSQL .= ” ORDER BY substrateTypeREF”;

$manufacturerSQL = “SELECT DISTINCT manufacturerREF, (SELECT manufacturer from manufacturers WHERE substrates.manufacturerREF = manufacturers.manufacturerREF) AS manufacturer FROM substrates WHERE 1″;
if (intval($textureREF) > 0)
$manufacturerSQL .= ” AND textureREF = “.$textureREF;
if (intval($blendREF) > 0)
$manufacturerSQL .= ” AND blendREF = “.$blendREF;
if (intval($substrateTypeREF) > 0)
$manufacturerSQL .= ” AND substrateTypeREF = “.$substrateTypeREF;
$manufacturerSQL .= ” ORDER BY manufacturer”;

$blendSQL = “SELECT DISTINCT blendREF, (SELECT blend from blends WHERE substrates.blendREF = blends.blendREF) AS blend, (SELECT sortOrder from blends WHERE substrates.blendREF = blends.blendREF) AS sortOrder FROM substrates WHERE 1″;
if (intval($manufacturerREF) > 0)
$blendSQL .= ” AND manufacturerREF = “.$manufacturerREF;
if (intval($textureREF) > 0)
$blendSQL .= ” AND textureREF = “.$textureREF;
if (intval($substrateTypeREF) > 0)
$blendSQL .= ” AND substrateTypeREF = “.$substrateTypeREF;
$blendSQL .= ” ORDER BY sortOrder”;

$textureSQL = “SELECT DISTINCT textureREF, (SELECT texture from textures WHERE substrates.textureREF = textures.textureREF) AS texture, (SELECT sortOrder from textures WHERE substrates.textureREF = textures.textureREF) AS sortOrder FROM substrates WHERE 1″;
if (intval($manufacturerREF) > 0)
$textureSQL .= ” AND manufacturerREF = “.$manufacturerREF;
if (intval($blendREF) > 0)
$textureSQL .= ” AND blendREF = “.$blendREF;
if (intval($substrateTypeREF) > 0)
$textureSQL .= ” AND substrateTypeREF = “.$substrateTypeREF;
$textureSQL .= ” ORDER BY sortOrder”;

// fire SQL
$fineArtResult = mysql_query($fineArtSQL);
$substrateTypeResult = mysql_query($substrateTypeSQL);
$manufacturerResult = mysql_query($manufacturerSQL);
$blendResult = mysql_query($blendSQL);
$textureResult = mysql_query($textureSQL);

?>

Comparison of Fine Art Papers, Photo Papers, and Canvas for Giclée Printmaking

Confused by the sheer number of options when evaluating substrates? Use the tables below to find exactly what you’re looking for. Use the dropdowns to filter the lists, and click on any column heading to sort. Creekside Digital can create 12-color archival pigment ink prints for you using any of these products. If you don’t see what you’re looking for, contact us — we can probably get it.

Type: Manufacturer: Blend: Texture:

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
}
?>

Substrate Type Swatch Weight Thickness Opacity Finish Texture Mould-made? Blend OBA?
“.$row[“manufacturerName”].” “.$row[“name”].” “.$row[“substrateType”].” “;
if ($row[“thumbnailFile”] != null) echo “\"".$row["manufacturerName"]."“;
echo “		 “.$row[“weight”].” g/sm “.$row[“thickness”].” mil “;
if ($row[“opacity”] != “0”) echo $row[“opacity”].”%”;
echo “		 “.$row[“finish”].” “.$row[“texture”].” “;
if ($row[“isMouldMade”] == “1”) echo “Yes”;
else echo “No”;
echo “		 “.$row[“blend”].” “;
if ($row[“oba”] == “1”) echo “Yes”;
else echo “No”;
echo “