Ací el block:
<?php
$result = db_query_range('SELECT node.nid, node_revisions.nid, node_revisions.uid, node_revisions.title,LEFT(node_revisions.teaser,126) as camp_tallat,users.uid, users.name,users.picture from (node LEFT JOIN node_revisions ON node.nid=node_revisions.nid) LEFT JOIN users ON users.uid=node.uid WHERE node.type=\'forum\' order by node.nid desc', 0,10);
?> <table> <?php
while ($myrow = mysql_fetch_array($result)) { ?>
<?php if (empty($myrow[picture])) { ?>
<tr><td valign="top"><img class="foto_block" width="70px" height="70px" src="http://www.pasportaservo.org/files/pictures/onklo_zam.jpg" alt="" /></td>
<?php } else { ?>
<tr><td valign="top"><img class="foto_block" width="70px" height="70px" src="/files/pictures/picture-<?php echo ($myrow[uid]);?>.jpg" alt="" /></td>
<?php } ?>
<td valign="top"><p class="lastaj_aldonoj"><a href="/node/<?php echo ($myrow[nid]); ?>"><?php echo ($myrow[title]);?></a><br /><?php echo ($myrow[camp_tallat]); ?>...</p></td></tr>
<?php } ?>
</table>
Envia un nou comentari