Some time ago, Era shared with you a Mysql database repeat detection function. For how to use this function, you can move to "Repeat detection function when mqsql data is stored in the database-php". today we will introduce two methods to count the number of rows in the Mysql database. Method 1: Use the statistical function count (); $ rsmysql_query (selectcount (*) FROMtm
Some time ago, Era shared with you a Mysql database repeat detection function. For how to use this function, you can move to "Repeat detection function when mqsql data is stored in the database-php". today we will introduce two methods to count the number of rows in the Mysql database. Method 1: Use the count (); $ rs = mysql_query ("select count (*) FROM tm
Some time ago, Era shared with you a Mysql database repeat detection function. For how to use this function, you can move to "Repeat detection function when mqsql data is stored in the database-php". today we will introduce two methods to count the number of rows in the Mysql database.
Method 1: Use the count () statistical function ();
$ Rs = mysql_query ("select count (*) FROM tmp_url"); $ firnnum = @ mysql_result ($ rs, 0); // query the number of rows in a temporary table
Method 2: Use the php Mysql system function mysql_num_rows ();
$ Rs = mysql_query ("select * FROM tmp_url"); $ firnnum = mysql_num_rows ($ rs );
Well, you can choose the specific method.
Original article address: two ways to count the number of rows in the Mysql database. Thank you for sharing it with the original author.