链表查询 php,咨询一个MYSQL+php的链表查询输出问题

咨询一个MYSQL+php的链表查询输出问题

sql php mysql select cms 表cms_archives15里的字段

aid mediumint(8) UNSIGNED 否 0

subject varchar(255) gbk_chinese_ci 否

jumpurl varchar(120) gbk_chinese_ci 否

caid smallint(5) UNSIGNED 否 0

chid tinyint(3) UNSIGNED 否 0

mid mediumint(8) UNSIGNED 否 0

mname char(15) gbk_chinese_ci 否

ucid mediumint(8) UNSIGNED 否 0

author char(30) gbk_chinese_ci 否

source varchar(50) gbk_chinese_ci 否

abstract text gbk_chinese_ci 否

keywords char(100) gbk_chinese_ci 否

thumb varchar(255) gbk_chinese_ci 否

imgnum tinyint(3) UNSIGNED 否 0

letter char(2) gbk_chinese_ci 否

vieworder smallint(6) UNSIGNED 否 500

initdate int(10) 否 0

createdate int(10) UNSIGNED 否 0

updatedate int(10) UNSIGNED 否 0

refreshdate int(10) 否 0

enddate int(10) 否 0

checked tinyint(1) UNSIGNED 否 0

customurl varchar(100) gbk_chinese_ci 否

nowurl varchar(255) gbk_chinese_ci 否

clicks int(10) UNSIGNED 否 0

downs int(10) UNSIGNED 否 0

mclicks int(10) UNSIGNED 否 0

wclicks int(10) UNSIGNED 否 0

mdowns int(10) UNSIGNED 否 0

wdowns int(10) UNSIGNED 否 0

mplays int(10) UNSIGNED 否 0

wplays int(10) UNSIGNED 否 0

dpmid smallint(6) 否 -1

plays int(10) UNSIGNED 否 0

dj float 否 0

dt varchar(40) gbk_chinese_ci 否

ggdt varchar(40) gbk_chinese_ci 否

dt_0 double 否 0

dt_1 double UNSIGNED 否 0

answercid mediumint(8) UNSIGNED 否 0

close tinyint(1) UNSIGNED 否 0

finishdate int(10) UNSIGNED 否 0

ccid1 smallint(6) UNSIGNED 否 0

ccid2 smallint(6) UNSIGNED 否 0

ccid3 smallint(6) UNSIGNED 否 0

ccid12 varchar(255) gbk_chinese_ci 否

ccid14 smallint(6) UNSIGNED 否 0

ccid18 smallint(6) UNSIGNED 否 0

pid3 mediumint(8) UNSIGNED 否 0

inorder3 smallint(6) UNSIGNED 否 0

incheck3 tinyint(1) UNSIGNED 否 0

aesfys int(10) UNSIGNED 否 0

aczfys int(10) UNSIGNED 否 0

lpczsl int(11) 否 0

lpesfsl int(11) 否 0

csjdj float 否 0

csjgz float 否 0

cspjj float UNSIGNED 否 0

czzdj float 否 0

czzgj float 否 0

czpjj float UNSIGNED 否 0

ahds int(10) UNSIGNED 否 0

azxs int(10) UNSIGNED 否 0

atps int(10) UNSIGNED 否 0

ahss int(10) UNSIGNED 否 0

adps int(10) UNSIGNED 否 0

adpf float UNSIGNED 否 0

ayss int(10) UNSIGNED 否 0

agzs int(10) UNSIGNED 否

pid5 mediumint(8) UNSIGNED 否 0

inorder5 smallint(6) UNSIGNED 否 0

incheck5 tinyint(1) UNSIGNED 否 0

pid6 mediumint(8) UNSIGNED 否 0

inorder6 smallint(6) UNSIGNED 否 0

incheck6 tinyint(1) UNSIGNED 否 0

color varchar(10) gbk_chinese_ci 否

relatedaid varchar(255) gbk_chinese_ci 否

ccid41 smallint(6) UNSIGNED 否 0

ccid51 smallint(6) UNSIGNED 否 0

ccid53 smallint(6) UNSIGNED 否 0

tid smallint(6) UNSIGNED 否 0

editorid mediumint(8) UNSIGNED 否 0

editor char(30) gbk_chinese_ci 否

from_mid mediumint(8) UNSIGNED 否 0

from_mname char(15) gbk_chinese_ci 否

needstatics varchar(255) gbk_chinese_ci 否

arctpls varchar(255) gbk_chinese_ci 否

awds int(10) UNSIGNED 否 0

atjs int(10) UNSIGNED 否

azbs int(10) UNSIGNED 否 0

ayxs int(10) UNSIGNED 否

ccid54 smallint(6) UNSIGNED 否 0

表cms_archives_4里的字段

字段 类型 整理 属性 Null 默认 额外 操作

aid mediumint(8) UNSIGNED 否 0

address varchar(150) gbk_chinese_ci 否

xkzh varchar(100) gbk_chinese_ci 否

dfl varchar(20) gbk_chinese_ci 否

lhl varchar(20) gbk_chinese_ci 否

yjl varchar(10) gbk_chinese_ci 否

wygs varchar(50) gbk_chinese_ci 否

wyf varchar(50) gbk_chinese_ci 否

qtbz varchar(255) gbk_chinese_ci 否

kprq varchar(50) gbk_chinese_ci 否

jfrq varchar(50) gbk_chinese_ci 否

jzmj varchar(10) gbk_chinese_ci 否

zdmj varchar(10) gbk_chinese_ci 否

cksm varchar(100) gbk_chinese_ci 否

content text gbk_chinese_ci 否

xqjs text gbk_chinese_ci 否

loupanlogo varchar(255) gbk_chinese_ci 否

lphf varchar(255) gbk_chinese_ci 否

tel varchar(100) gbk_chinese_ci 否

sldz varchar(255) gbk_chinese_ci 否

xqss varchar(150) gbk_chinese_ci 否

jtxl varchar(150) gbk_chinese_ci 否

zxcd int(10) 否 0

jgjj float 否 0

jdjj float 否 0

bdsm varchar(255) gbk_chinese_ci 否

ltbk varchar(255) gbk_chinese_ci 否

lpbbs varchar(10) gbk_chinese_ci 否

xqhs varchar(10) gbk_chinese_ci 否

jgdate int(10) 否 0

lppmtu varchar(255) gbk_chinese_ci 否

wydz varchar(200) gbk_chinese_ci 否

leixing varchar(1) gbk_chinese_ci 否 0

lcs varchar(10) gbk_chinese_ci 否

hxs int(10) 否 0

tslp varchar(255) gbk_chinese_ci 否

fkxs varchar(255) gbk_chinese_ci 否

lpxz varchar(255) gbk_chinese_ci 否

dtsm text gbk_chinese_ci 否

表cms_housesrecords里的字段

字段 类型 整理 属性 Null 默认 额外 操作

cid int(10) UNSIGNED 否 auto_increment

aid mediumint(9) UNSIGNED 否

isnew tinyint(1) 否

highest float UNSIGNED 否

average float UNSIGNED 否

lowest float UNSIGNED 否

message varchar(255) gbk_chinese_ci 否

createdate int(11) UNSIGNED 否

需要实现的功能是如果上次记录的价格高于本次记录价格输出↑相同→下降↓

以下是代码，帮看看，死活不出来东西。

$sql = "SELECT a.`aid`,a.`subject` FROM cms_archives15 a LEFT JOIN cms_archives_4 c ON (c.aid=a.aid) WHERE a.caid ='2' AND a.chid='4' AND (c.leixing='0' OR c.leixing='1') AND `ccid1` = '211' ORDER BY a.updatedate DESC LIMIT 0,80";

$query = mysql_query($sql);

while($arr = mysql_fetch_array($query)){

$jgsql = "select `average` from `cms_housesrecords` where `aid` = '".$arr['aid']."' order by `createdate` desc limit 2";

$jgquery = mysql_query($jgsql);

$i=0;

while($jgarr = mysql_fetch_array($jgquery)){

if($i<1){

$f_jiage = $jgarr['average'];

}else{

$s_jiage = $jgarr['average'];

}

$i++;

}

if($f_jiage>$s_jiage){

$jgstyle = '↑';

}

elseif($f_jiage==$s_jiage){

$jgstyle = '→';

}else{

$jgstyle = '↓';

}

?>

.html">=$arr['subject']?>=$f_jiage?>元=$jgstyle?>

}

?>

以上是我写的一段房价对比的查询输出，但却啥也不显示，高手们给指点下，看是不是少了什么字段，或者忘记了什么东西呢？

回复讨论(解决方案)

信息量太大 眼晕 有重点么

一步步的调试；输出$jgarr 看看，再根据if进行对比。

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网