PHP SQL Number of Rows
This example illustrates how to count the rows of the table.
To understand how to count the number of rows in a table, we have created a sql_num_rows.php file. If you are not connected to the database, then create a connection first using mysql_connect("hostName", "userName", "Password") and mysql_select_db("databaseName", connectionObject). Now the query can be executed using mysql_query("SELECT * FROM tableName"). The number of rows are returned by the mysql_num_rows() method.
Table: users
Source Code of sql_num_rows.php
<?php
|
Download Source Code
Output: