[Resolved] how to count the number of records in a DB

jacksonpt

I want to display the number of records in a DB with no other info. I thought COUNT would do it, but according to my book, it has to be used with another arguement (usually SELECT).

I have a DB for registrations, and I want to display the total number of registrations. Can someone help me out?

LordShryku

Is this one table or many?
For each table:

SELECT count(*) FROM table

jacksonpt

That works from the command line, but how do you display the results of that query on a webpage?

LordShryku

<?php
$conn = mysql_connect("server","user","pass");
mysql_select_db("db_name");
$sql = "SELECT count(*) FROM table";
$res = mysql_query($sql);
$row = mysql_fetch_row($res);
echo $row[0];
mysql_close($conn);
?>

jacksonpt

Ah, very cool - thanks.