这里在supesite表中一个主表，supe_spaceitems与supe_attachments附件表，我们通过left jon查找 出有图片附件的记录出来。
代码如下 复制代码
mysql教程_connect('localhost','root','root');
mysql_select_db('abc');
mysql_query(set names 'gbk');
$sql = select a.itemid,a.lastpost,a.city,b.thumbpath from supe_spaceitems a left join supe_attachments b on a.itemid = b.itemid where a.picid>0 order by a.itemid desc limit 0,3;
$query = mysql_query( $sql );
while( $k = mysql_fetch_array( $query ) )
{
$str .= ;
}
echo $str;