طالعت الملف الاندكس لسكربت الدروس للأخ صالح المطرفي (أشكره)
استخدمت LEFT JOIN وفي النهاية أنشأت حلقة واحدة في القالب
كود PHP:
//get posts
$Sql = "SELECT *, SUBSTRING_INDEX(content, '^_^', 1) AS content FROM posts WHERE intrash='0' AND approve='1' AND setID='$_GET[set]' AND category_id='$_GET[cat]' AND module_id='$getcurrent_mod[moduleid]' ORDER BY ordering ASC";
$Result = mysql_query($Sql);
while ($Row = @mysql_fetch_array($Result))
{
$num = mysql_query("SELECT * FROM attachments AS attachments
LEFT JOIN posts AS posts ON (posts.id = $Row[id])
WHERE attachments.post_id=$Row[id] AND attachments.thumbfirst = '1'");
$num_first = mysql_num_rows($num);
$getthumb = mysql_fetch_array($num);
if ($num_first ==1){
$Row[CodeImage] = "<img border=\"0\" src=\"$getthumb[urlthumb]\" alt=\"$Row[subject] \">";
}else{
$Row[CodeImage] = "<img border=\"0\" src=\"templates/default/empty.png\" alt=\"$Row[subject] \">";
}
$p[] = $Row;
}
والقالب:
كود HTML:
<!--posts-->
<IF NAME="{p}">
<LOOP Name="{p}" LIMIT="5">
<div class="r">
{{CodeImage}}
</div>
<div class="l subject">
<a class="subject" href="?set={{setID}}&cat={{category_id}}&item={{id}}">{{subject}}</a><br />
{{content}}<br />
</div><div class="cls"></div>
</LOOP>
<div class="paging">{p_paging}</div>
</IF>