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?>
}
?>
以上是我写的一段房价对比的查询输出，但却啥也不显示，高手们给指点下，看是不是少了什么字段，或者忘记了什么东西呢？
回复讨论(解决方案)
信息量太大 眼晕 有重点么
一步步的调试；输出$jgarr 看看，再根据if进行对比。
