Home > Article > Backend Development > 咨询一个MYSQL+php的链表查询输出问题
咨询一个MYSQL+php的链表查询输出问题
- WBOYOriginal
- 2016-06-23 14:25:571070browse
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进行对比。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：分享链接 php+ajax实现内容获取与动态修改Next article：请问怎么获取域名并自动保存啊