数据库结构user_id user_name f1
1 vipstar
2 abcde 1
3 testa 2
4 abba 1我现在想获取f1为"1" 的用户,代码如下
<?php
$con=new mysqli("localhost","123","pass123","123");
//mysql_select_db("123");
$sql="select user_id, user_name from ecm_member where f1='1'";
$result=$con->query($sql,MYSQLI_STORE_RESULT);
while(list($uid,$uname)=$result->fetch_row());
echo $uid;
?>
可输出的结果为空,,,请指教,谢谢
1 vipstar
2 abcde 1
3 testa 2
4 abba 1我现在想获取f1为"1" 的用户,代码如下
<?php
$con=new mysqli("localhost","123","pass123","123");
//mysql_select_db("123");
$sql="select user_id, user_name from ecm_member where f1='1'";
$result=$con->query($sql,MYSQLI_STORE_RESULT);
while(list($uid,$uname)=$result->fetch_row());
echo $uid;
?>
可输出的结果为空,,,请指教,谢谢
echo $uid;
}对于
while(list($uid,$uname)=$result->fetch_row());
只在 $result->fetch_row() 返回空时才退出循环,所以$uid为空
f1=1吧应该,如果你的字段类型不是varchar类型
$result是个二维数组,用foreach循环就行了
{
echo $rs["user_id"].$rs["user_name"];
}
$host="";
$user="";
$pass="";
$link=mysql_connect($host,$user,$pass) or die ("连不上数据库");
mysql_query("SET NAMES 'utf8'",$link);
mysql_select_db(数据库名);
$sql="select * from table where f1=1";
$result=mysql_query($sql);
while($rs = mysql_fetch_array($result))
{
echo $rs["user_id"].$rs["user_name"];
}