執(zhí)行這個(gè)SQL

創(chuàng)新互聯(lián)公司主營(yíng)陽(yáng)新網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營(yíng)網(wǎng)站建設(shè)方案,成都app開發(fā),陽(yáng)新h5小程序設(shè)計(jì)搭建,陽(yáng)新網(wǎng)站營(yíng)銷推廣歡迎陽(yáng)新等地區(qū)企業(yè)咨詢
select user.id, user.pic, user.username, info.page_total
from user
join info on user.id = info.id
order by RAND()
limit 2
把結(jié)果放在數(shù)組里就成了
As the flagship of the LEXUS auto type, LS owns an inresistably powerful engine and nobleness, which illustrates its excellent designing conception as morden sedan. LEXUS brings us into a new horizon of the aerodynamic sesign, powerful performance, regal decoration and advanced security protection of a sedan. With easy driving, delicate design and rapid and sensible action as the utmost performances, LEXUS LS series tell us what is real luxury. Lofty, elegance and flexible make the delicate body and innovated science/tech an integration, and produce the LEXUS luxurious sedans with mature science and technology and good quality. Elegant appearence and powerful engine make the sedan as your royal residence. LEXUS LS460/LS460L owns lots of world top technology, especially in initiative and passive security protection. Remarkbly, unlimited reserve of power with smooth output makes your driving comfortable and stable
$result?=?mysql_query($sql);
while?($row=mysql_fetch_row($result))
{
$data[]=$row;
}
print_r($data);
首先這兩個(gè)表得有個(gè)關(guān)聯(lián)字段,進(jìn)行關(guān)聯(lián)后用concat(a.col1,b.col2)這樣即可把第一個(gè)表的col1,和第二個(gè)表的col2字段連接在一起輸出
樓主可以用curl_exec() 從一個(gè)頁(yè)面訪問另外一個(gè)頁(yè)面 拿到你的json 然后 json_decode一下 然后跟你本地的進(jìn)行對(duì)比就好了
整合用戶用ucenter就行,它是專門干這個(gè)的
而且ecshop和discuz都有相應(yīng)的接口,填寫一些信息就可以完成
至于跨數(shù)據(jù)庫(kù)顯示內(nèi)容,可以做一個(gè)api接口,這個(gè)接口只是鏈接另一個(gè)數(shù)據(jù)庫(kù),然后根據(jù)相應(yīng)的參數(shù)取不同的數(shù)據(jù),然后再需要顯示的地方調(diào)用這個(gè)接口就行
至于怎么調(diào)用,用iframe,ajax都可以
當(dāng)前名稱:mysql怎么拼兩個(gè)數(shù)組,mysql拼接兩張表
文章出自:http://chinadenli.net/article17/dsgpjgj.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供外貿(mào)建站、網(wǎng)站維護(hù)、App開發(fā)、建站公司、標(biāo)簽優(yōu)化、軟件開發(fā)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)