计算MySQL数据库中的记录的条数的命令是什么来着? select count(0) from tablename 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select count(*) as Num from tablename <?php mysql_connect("localhost","user","password"); mysql_select_db("database"); $sql = "SELECT count(*) AS Num FROM `tablename`"; $res = mysql_query($sql); $row = mysql_fetch_assoc($res); echo $row['Num'];?> <?$sql="select count(0) from tablename";$result=mysql_query($sql);$total=mysql_result($result,0);?> $sql= "SELECT * FROM tablename";$result = mysql_query ($sql, $connection);$total=mysql_num_rows($result); 努力了好几天,我自己的一个小项目,请大家提提意见。 php中这个符号“->”是社么意思 preg_replace怎么替换不了 为什么我帮别人答题,人家也给我分了,我却没加上呢? 大家快帮帮我呀。。不同版本的网站制作问题???急!!先谢谢了!! 无缘无故的php就报错!急救ing 讨论一下PHP代码与效率的问题 代码出错,请高手看看! 哪儿有PHP4做的身份验证与上传文件的例子? 请前辈们介绍一个好的接收邮件类 怎么来写文章页的内翻页,能提供代码 2个数据库数据替换问题?
mysql_connect("localhost","user","password");
mysql_select_db("database");
$sql = "SELECT count(*) AS Num FROM `tablename`";
$res = mysql_query($sql);
$row = mysql_fetch_assoc($res);
echo $row['Num'];
?>
$result=mysql_query($sql);
$total=mysql_result($result,0);?>
$result = mysql_query ($sql, $connection);$total=mysql_num_rows($result);