Chakotay2004 寫:問一下站長大大
合併這個該怎麼做啊?
能寫個範例嗎?
SQL我還是新手~~~感謝
試試這樣:
- 代碼: 選擇全部
//######################## pet ##############################
$sql="select a.pe_p_id ,pe_name ,a.pe_at ,b.i_img from wog_pet a, wog_player b where a.pe_p_id=b.p_id order by a.pe_at desc LIMIT 10 ";
$p=$DB_site->query($sql);
$s="";
while($ps=$DB_site->fetch_array($p))
{
$s.=";".$ps["i_img"].",".$ps["pe_name"].", ".$ps["pe_at"]." AT";
}
$s=substr($s,1,strlen($s));
$DB_site->free_result($p);
echo "parent.king_view('<font size=3 color=#CCFF99>寵物 TOP</font>','$s');\n";
echo "parent.wog_view.document.write('<hr size=1 color=#A2A9B8>');\n";