Hi guys, thanks for the replies. The code I am using is
$flag1result = mysql_query("SELECT flag FROM cf_flag, propertyFlag WHERE propertyID=".$row['propertyID']." AND propertyFlag.flagID=cf_flag.flagID") or die(mysql_error());
while ($flag1row=mysql_fetch_array($flag1result)) {
if ($flag1row['flag']=="Sold STC") {
$flagtype = "soldstc";
}
if ($flag1row['flag']=="Under Offer") {
$flagtype = "underoffer";
}
}
$query=("SELECT domainURL,imageName from image where propertyID=".$row["propertyID"]." order by imageName limit 1");
$result2=mysql_query($query);
//$image=mysql_num_rows($result2);
//add watermark
if ($flagtype=="soldstc") {
$watermark = imagecreatefrompng('images/watermark_soldstc.png');
}
if ($flagtype=="underoffer") {
$watermark = imagecreatefrompng('images/watermark_underoffer.png');
}
if ($flagtype=="") {
$watermark = imagecreatefrompng('images/watermark_blank.png');
}
$watermark_width = imagesx($watermark);
$watermark_height = imagesy($watermark);
//
IF ($row2 = mysql_fetch_array($result2))
{
$image1 = imagecreatefromjpeg($row2["domainURL"]."/".$row['propertyID']."_".$row2["imageName"]."_thumbnail.jpg");
$size = getimagesize($row2["domainURL"]."/".$row['propertyID']."_".$row2["imageName"]."_thumbnail.jpg");
}
ELSE
{
$image1 = imagecreatefromjpeg('images/awaiting_small.jpg');
$size = getimagesize('images/awaiting_small.jpg');
}
$dest_x = $size[0] - $watermark_width - 5;
$dest_y = $size[1] - $watermark_height - 5;
imagecopymerge($image1, $watermark, $dest_x, $dest_y, 0, 0, $watermark_width, $watermark_height, 100);
header("Content-Type: image/jpeg"); imagejpeg($image1); imagedestroy($image1);
imagedestroy($watermark);