SELECT * FROM 表 WHERE 手机号码 IN (SELECT 手机号码 FROM 表 GROUP BY 手机号码 HAVING COUNT(手机号码) > 5)
$sql = "SELECT * FROM housesell WHERE sjhm IN (SELECT sjhm FROM housesell GROUP BY sjhm HAVING COUNT(sjhm) > 5)"; $query = mysql_query($sql); @$row = mysql_fetch_array($query);
select id from table where number=x limit 5,1能查到说明有6条,最简单
按照4楼的方法我试了还是不行我把代码全部贴出来 <?php if (strlen($q) > 0) { $conn = @mysql_connect("localhost","root","123") or die ("MySql连接错误"); mysql_select_db("fangke_cc",$conn); header("Content-Type:text/html;charset=GB2312");
$sql = "SELECT * FROM housesell"; $query = mysql_query($sql); while($row=mysql_fetch_array($query)){ $query1=mysql_query("select count(sjhm) as hm from housesell where sjhm='$row['sjhm']'"); $row1=mysql_fetch_array($query1); if ($row1['sjhm']>=5){ $response = "<font color=red >该手机已经发满5条</font>"; } else{ $num=5-$row1['sjhm']; $response = "<font color=blue >该手机还可以发".$num."条</font>"; } echo $response; }?> 报这个错误:Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in E:\wwwroot2\lefangke\web\yz\conn.php on line 13我看了一下,按四楼的方法是引号引起的错误,但是我把单引号改成双引号就不能验证了
楼主认真看看我们代码有什么不同,你就全部复制过去看一下,不要做任何修改<?php if (strlen($q) > 0) { $conn = @mysql_connect("localhost","root","123") or die ("MySql连接错误"); mysql_select_db("fangke_cc",$conn); header("Content-Type:text/html;charset=GB2312"); $sql = "SELECT * FROM housesell"; $query = mysql_query($sql); while($row=mysql_fetch_array($query)){ $sjhm=$row['sjhm']; $query1=mysql_query("select count(sjhm) as hm from housesell where sjhm='$sjhm'"); $row1=mysql_fetch_array($query1); if ($row1['hm']>=5){//这个是$row[hm]而不是$row[sjhm] $response = "<font color=red >该手机已经发满5条</font>"; } else{ $num=5-$row1['hm'];//这个是$row[hm]而不是$row[sjhm] $response = "<font color=blue >该手机还可以发".$num."条</font>"; } echo $response; }?>
13楼,你知道数据库的查询方法吗? 我们查的是一次 select id from table where number=x limit 5,1 select知道是什么意思吗 先去看看sql语句的运行机制好吗! 你这样很容易误导别人!
1楼的方法是好 SELECT * FROM 表 WHERE 手机号码 IN (SELECT 手机号码 FROM 表 GROUP BY 手机号码 HAVING COUNT(手机号码) > 5)但是你看到了吗有两个SELECT 证明它的查询步邹是先查询出一个结果集(你可以理解为虚拟表) 然后在此基础上再进行查询。 好的程序使用最简单的方法完成任务 明白吗?
$query = mysql_query($sql);
@$row = mysql_fetch_array($query);
if(!empty($row['sjhm']))
{
$response = "<font color=red >该手机已经发满5条</font>";
}else
{
$response = "<font color=blue >该手机还可以发 条</font>";
}
echo $response;我按照你写的不行啊
$query = mysql_query($sql);
while($row=mysql_fetch_array($query)){
$query1=mysql_query("select count(sjhm) as hm from housesell where sjhm='$row['sjhm']'");
$row1=mysql_fetch_array($query1);
if ($row1['hm']>=5){
$response = "<font color=red >该手机已经发满5条</font>";
}
else{
$num=5-$row1['hm'];
$response = "<font color=blue >该手机还可以发".$num."条</font>";
}echo $response;
}别忘记给分!不过不得不承认1楼方法不错!
<?php
if (strlen($q) > 0)
{
$conn = @mysql_connect("localhost","root","123") or die ("MySql连接错误");
mysql_select_db("fangke_cc",$conn);
header("Content-Type:text/html;charset=GB2312");
$sql = "SELECT * FROM housesell";
$query = mysql_query($sql);
while($row=mysql_fetch_array($query)){
$query1=mysql_query("select count(sjhm) as hm from housesell where sjhm='$row['sjhm']'");
$row1=mysql_fetch_array($query1);
if ($row1['sjhm']>=5){
$response = "<font color=red >该手机已经发满5条</font>";
}
else{
$num=5-$row1['sjhm'];
$response = "<font color=blue >该手机还可以发".$num."条</font>";
} echo $response;
}?>
报这个错误:Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in E:\wwwroot2\lefangke\web\yz\conn.php on line 13我看了一下,按四楼的方法是引号引起的错误,但是我把单引号改成双引号就不能验证了
if (strlen($q) > 0)
{
$conn = @mysql_connect("localhost","root","123") or die ("MySql连接错误");
mysql_select_db("fangke_cc",$conn);
header("Content-Type:text/html;charset=GB2312"); $sql = "SELECT * FROM housesell";
$query = mysql_query($sql);
while($row=mysql_fetch_array($query)){
$sjhm=$row['sjhm'];
$query1=mysql_query("select count(sjhm) as hm from housesell where sjhm='$sjhm'");
$row1=mysql_fetch_array($query1);
if ($row1['hm']>=5){//这个是$row[hm]而不是$row[sjhm] $response = "<font color=red >该手机已经发满5条</font>";
}
else{
$num=5-$row1['hm'];//这个是$row[hm]而不是$row[sjhm]
$response = "<font color=blue >该手机还可以发".$num."条</font>";
} echo $response;
}?>
我们查的是一次
select id from table where number=x limit 5,1
select知道是什么意思吗
先去看看sql语句的运行机制好吗!
你这样很容易误导别人!
SELECT * FROM 表 WHERE 手机号码 IN (SELECT 手机号码 FROM 表 GROUP BY 手机号码 HAVING COUNT(手机号码) > 5)但是你看到了吗有两个SELECT
证明它的查询步邹是先查询出一个结果集(你可以理解为虚拟表)
然后在此基础上再进行查询。
好的程序使用最简单的方法完成任务
明白吗?