"; $result = mysql_query($sql); if (mysql_errno()) {echo mysql_errno().": ".mysql_error()."
";} if ($myrow=mysql_fetch_array($result)) { $picture=$myrow['src']; $pictype=$myrow['imgtype']; $image=imageCreateFromString($picture); $img_width=imagesx($image); $img_height=imagesy($image); //apply watermark if required //NB watermark image should be saved to site as alt='watermark.png' $siteid=$myrow['siteid']; $sql="SELECT * FROM image WHERE siteid=$siteid AND alt='watermark.png'"; $result = mysql_query($sql); if (mysql_errno()) {echo mysql_errno().": ".mysql_error()."
";} if (($mywatermark=mysql_fetch_array($result)) && ($img_width>499)) { $watermark = imageCreateFromString($mywatermark['src']); $watermark_width = imagesx($watermark); $watermark_height = imagesy($watermark); Header("Content-type: $pictype"); imagecopymerge($image, $watermark, 5, 5, 10, 10, $watermark_width, $watermark_height, 45); imagejpeg($image); imagedestroy($image); imagedestroy($watermark); } else { Header("Content-type: $pictype"); echo $picture; } } }; ?>