怎么把mysql的一个表中的记录数赋值给一个变量？？
怎么把mysql的一个表中的记录数赋值给一个变量？？ 问题点数：10、回复次数：7Top
1 楼aniude（重返荣耀）回复于 2006-03-12 23:56:49 得分 1
eg
$result=mysql_query("select columnName from tableName");
$array=mysql_fetch_array($result);
echo "列值为".$array[0];Top
2 楼helloyou0（你好！）回复于 2006-03-13 06:56:14 得分 2
list($count)=mysql_fetch_row(mysql_query("select count(*) from table "));Top
3 楼arcow（冲星）回复于 2006-03-13 09:44:35 得分 1
select count(*) as counts from tableTop
4 楼tgq1981（全娃）回复于 2006-03-13 09:58:00 得分 1
$sqlstr = "Select id From table";
$rows = mysql_num_rows(mysql_query($sqlstr,$conn);
print($rows);Top
5 楼tgq1981（全娃）回复于 2006-03-13 09:59:02 得分 2
$sqlstr = "Select id From table";
$rows = mysql_num_rows(mysql_query($sqlstr,$conn)); //纠正
print($rows);
Top
6 楼xuzuning（唠叨）回复于 2006-03-13 10:01:23 得分 2
$rs = mysql_query('select count(*) from tbl_name');
list(,$cnt) = mysql_fetch_row($rs);
Top
7 楼zeroleonhart（Strong Point:Algorithm）回复于 2006-03-13 17:09:58 得分 1
用select count(*) from tableTop
