$result = mysql_query
("SELECT a.id,a.hao1,a.hao2,a.hao3,b.id - a.id AS sub
FROM mydb1 a, mydb1 b
WHERE a.hao1 = b.hao1 && a.hao2 = b.hao2 && a.hao3 = b.hao3
HAVING sub >0");
while($row = mysql_fetch_array($result))
{if($row['hao1']==3&&$row['hao2']==4&&$row['hao3']==5)
{echo $row['id'].''.$row['sub'];}}请各位老师帮我看看哪错了,我想输出字段内容都是345的,用它们对应的id按先后顺序相减输出差。PHPMySQL
("SELECT a.id,a.hao1,a.hao2,a.hao3,b.id - a.id AS sub
FROM mydb1 a, mydb1 b
WHERE a.hao1 = b.hao1 && a.hao2 = b.hao2 && a.hao3 = b.hao3
HAVING sub >0");
while($row = mysql_fetch_array($result))
{if($row['hao1']==3&&$row['hao2']==4&&$row['hao3']==5)
{echo $row['id'].''.$row['sub'];}}请各位老师帮我看看哪错了,我想输出字段内容都是345的,用它们对应的id按先后顺序相减输出差。PHPMySQL
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货