Counting Databases

rapmonkey

Is there a way to just count how many entries there are in an SQL database and then display it in a PHP page? If so how would I do it?

bladx

http://www.mysql.com/doc/en/mysql_num_rows.html

mysql_num_rows();

ereimber

Maybe you want to count the numbers of entries in a table.
You can do:

select count(*) from myTable.

Erich

rapmonkey

ok, I got the count selected (I think) but how would I display the number of entries?

Here is my code:

// setup a query variable to ask the database for some information
$query = "SELECT COUNT (*) FROM currentgames";

// acctualy ask for the info & store it in $results
$result = mysql_query($query) or die("Could not store database info in temporary results.");

bladx

Here is a way you can do this: (remember that the only part you really need is this part:

while ($row = mysql_fetch_array($result)) {
echo "Total Number of Rows: ".$row[0];
}

Here is the whole snippet:

$db = mysql_connect("localhost", "your_user", "your_pass") or die("mysql_connect() failed");
mysql_select_db("your_database") or die("mysql_select() failed");
$query = "select count(*) from currentgames";
$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {
echo "Total Number of Rows: ".$row[0];
}

Hope it helps.