Hi I am writing a little mod so I can view postcards people have sent from my site. I have come up with the following code but it needs a tiny tweak which I'm having problems with. Can anyone help? Heres the code.
<?PHP
$result = "SELECT p.postcard_id, p.image_id, p.postcard_date, p.postcard_bg_color, p.postcard_border_color, p.postcard_font_color, p.postcard_font_face, p.postcard_sender_name, p.postcard_sender_email, p.postcard_recipient_name, p.postcard_recipient_email, p.postcard_headline, p.postcard_message, i.image_name, i.cat_id, i.image_media_file, i.image_thumb_file, p.postcard_confirm
FROM ".POSTCARDS_TABLE." p, ".IMAGES_TABLE." i
WHERE p.image_id = i.image_id";
while($row = mysql_fetch_array($result))
{
$postcard_id = $row["postcard_id"];
$postcard_date = date("D d M, Y g:i a", $row["postcard_date"]);
$image_id = $row["p.image_id"];
$postcard_bg_color = $row["p.postcard_bg_color"];
$postcard_border_color = $row["p.postcard_border_color"];
$postcard_font_color = $row["p.postcard_font_color"];
$postcard_font_face = $row["p.postcard_font_face"];
$postcard_sender_name = $row["p.postcard_sender_name"];
$postcard_sender_email = $row["p.postcard_sender_email"];
$postcard_recipient_name = $row["p.postcard_recipient_name"];
$postcard_recipient_email = $row["p.postcard_recipient_email"];
$postcard_headline = $row["p.postcard_headline"];
$postcard_message = $row["p.postcard_message"];
$cat_id = $row['i.cat_id'];
$image_media_file = $row[i.'image_media_file'];
echo <<<END
<table cellspacing="0" cellpadding="1" align="center" border="0">
<tbody>
<tr>
<td bgcolor="$postcard_border_color"><table cellspacing="0" cellpadding="10" bgcolor="$postcard_bg_color" border="0">
<tbody>
<tr>
<td valign="top"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">$postcard_date</font><br><a href="/details.php?image_id=$image_id" target="_blank"><img src="/data/media/$cat_id/$image_media_file" border="0"></a><br>
<br> <font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">$postcard_recipient_name - </font>
<a href="mailto:$postcard_recipient_email"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">$postcard_recipient_email</font></a></td>
<td valign="top" width="200" height="250"><div align="right"><img src="/templates/myleeneklass/images/stamp.gif" border="0"></div>
<br> <br> <b><font face="$postcard_font_face" color="$postcard_font_color" size="4">$postcard_headline</font></b><br>
<br> <font face="$postcard_font_face" color="$postcard_font_color" size="2">$postcard_message</font><br>
<br> <font face="$postcard_font_face" color="$postcard_font_color" size="2">$postcard_sender_name</font><br> <a href="mailto:$postcard_sender_email"><font
face="$postcard_font_face" color="$postcard_font_color" size="2">$postcard_sender_email</font></a></td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table><br>
END;
}
?>
Thanks in advance
Carl