一个极菜的问题[100分] 执行这语句,然后取得的第一个字段就是这样if not rs.eof then count=rs(1) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $sql = "select count(*) as count from tableName";$result = mysql_query($sql);$row = mysql_fetch_array($result);echo $row[count];//显示你查询的数量 mysql> use mysqlDatabase changedmysql> SELECT COUNT(*) FROM user;+----------+| COUNT(*) |+----------+| 4 |+----------+1 row in set (0.05 sec)mysql> SELECT @User_Count := COUNT(*) FROM user;+-------------------------+| @User_Count := COUNT(*) |+-------------------------+| 4 |+-------------------------+1 row in set (0.05 sec)mysql> SELECT @User_Count;+-------------+| @User_Count |+-------------+| 4 |+-------------+1 row in set (0.00 sec)mysql> SELECT @User_Count;+-------------+| @User_Count |+-------------+| 4 |+-------------+1 row in set (0.00 sec)mysql> SELECT @User_Count,@User_Count-1,@User_Count*4;+-------------+---------------+---------------+| @User_Count | @User_Count-1 | @User_Count*4 |+-------------+---------------+---------------+| 4 | 3 | 16 |+-------------+---------------+---------------+1 row in set (0.01 sec)mysql> 如何动态创建一个数据库呀 mysql打开远程数据表问题 mysql 创建外键提示ERROR 1064(42000)错误,谢谢 mysql表里面有部分内容存成了更gb2312,怎么转成utf8? 如何用数据库来制作菜单 我用VC进行MySql的开发,用ADO方法,为什么写入数据的时候会出错? 哪有PostGreSql for window的下载? 隐藏MySQL 版本信息 如何给一个已存在的表单插入一个列? mysql_comp.jar和mm.mysql-2.0.4-bin.jar有什么区别呀? 怎么在C程序中调用MySQL数据库 InnoDB 中文参考手册 ----- 翻译结束!!!
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo $row[count];//显示你查询的数量
Database changed
mysql> SELECT COUNT(*) FROM user;
+----------+
| COUNT(*) |
+----------+
| 4 |
+----------+
1 row in set (0.05 sec)mysql> SELECT @User_Count := COUNT(*) FROM user;
+-------------------------+
| @User_Count := COUNT(*) |
+-------------------------+
| 4 |
+-------------------------+
1 row in set (0.05 sec)mysql> SELECT @User_Count;
+-------------+
| @User_Count |
+-------------+
| 4 |
+-------------+
1 row in set (0.00 sec)mysql> SELECT @User_Count;
+-------------+
| @User_Count |
+-------------+
| 4 |
+-------------+
1 row in set (0.00 sec)mysql> SELECT @User_Count,@User_Count-1,@User_Count*4;
+-------------+---------------+---------------+
| @User_Count | @User_Count-1 | @User_Count*4 |
+-------------+---------------+---------------+
| 4 | 3 | 16 |
+-------------+---------------+---------------+
1 row in set (0.01 sec)mysql>