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

表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 = '↓';

 }

 ?>

<li>
<a target="_blank" href="http://www.qf101.com/archive-htm-aid-<?=$arr['aid']?>.html"><?=$arr['subject']?></a><?=$f_jiage?>元
 <?=$jgstyle?>
</li>
<? }
?>以上是我写的一段房价对比的查询输出，但却啥也不显示，高手们给指点下，看是不是少了什么字段，或者忘记了什么东西呢？sqlphpmysqlselectcms

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

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