mysql中不用存储过程可不可以使用while,如果可以的话怎么用?
发布网友
发布时间：2022-04-25 16:50
共1个回答
热心网友
时间：2022-04-07 22:32
$db_host = "ip";
$db_user = "用户名";
$db_password = "密码";
$db_name = "数据库名";
mysql_connect($db_host,$db_user,$db_password);
mysql_select_db($db_name);
//自定义查询，就是写SQL
$sql = "select count(*) as num from students where age>20";
$result = mysql_query($sql);
//取数据，当然一条的时候也可以直接 $row['num']
while ($row = mysql_fetch_array($result)) {
$row['num']
}
?>
