咨询一个MYSQL+php的链表查询输出问题-tutoriel php-php.cn

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

WBOY

Libérer： 2016-06-23 14:25:57

original

1072 Les gens l'ont consulté

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                         $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?>

}
?>

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