SupeSite uses joinleft to query the news table with Image Attachment records-PHP source code

Here we have a primary table in the supesite table, supe_spaceitems and supe_attachments attachment tables. We can use leftjon to find records with image attachments. Here we have a primary table in the supesite table, supe_spaceitems and supe_attachments attachment tables. We can use left jon to find records with image attachments.

Script ec (2); script

The Code is as follows:
Mysql tutorial _ connect ('localhost', 'root', 'root '); Mysql_select_db ('abc '); Mysql_query ("set names 'gbk '"); $ SQL = "select. itemid,. lastpost,. city, B. thumbpath from supe_spaceitems a left join supe_attachments B on. itemid = B. itemid where. picid> 0 order by. itemid desc limit 0, 3 "; $ Query = mysql_query ($ SQL ); While ($ k = mysql_fetch_array ($ query )) { $ Str. = ""; }

Echo $ str;