这里在supesite表中一个主表,supe_spaceitems与supe_attachments附件表,我们通过left jon查找 出有图片附件的记录出来。
| 代码如下 | 复制代码 |
|
mysql教程_connect('localhost','root','root'); $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"; |
|
echo $str;










