php将SQL查询结果赋值给变量

显示全部楼层 · 2017-11-25 01:06:21

你是只取这一个值还是要取数组。只取一个的话。$sql = "select field1 from pre_common_member_profile where uid='$username'";$query = mysql_query($sql);$bianliang = mysql_result($query,0);echo $bianliang;取数组的话。$sql = "select field1 from pre_common_member_profile where uid='$username'";$query = mysql_query($sql);while($row = mysql_fetch_array($quer...

千问 · 2017-11-25 01:06:21

$sql = "select field1 from pre_common_member_profile where uid='$username'";$result = mysql_query($sql);while($row = mysql_fetch_array($result)){
$number = $row[0];//按照...

千问 · 2017-11-25 01:06:21

将"while($row = mysql_fetch_array($result)){" 改为 $row = mysql_fetch_array($result);因为循环结束时$row的结果会为空....

千问 · 2017-11-25 01:06:21

mysql_query()mysql_fetch_array...