Search → counting records in a database table

Counting records in PHP/mySQL

Following code samples, demonstrates how to count records in a MySQL database table. You may send parameters to query to display only selected range of rows.

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • Freeware

Counting Records in SQL Script

Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Windows
• Licenses
  • Freeware

Counting Records In A Database Table

We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware