[Resolved] Database entry count

[fean0r]

Is there away to count how many entrys in a mysql database without doing a loop?

[laserlight]

hmm... the sum of the number of records in the whole database?

is the restriction on loops necessary?

I suspect that the only strict solution would be to count them yourself, but then one may argue that you are doing the iteration so it isnt allowed.

[fean0r]

I dont mind doing a loop to count it, I just thought there might have been an quiker way...

I basically want to count how many registered users I have in the 'users' database I thought there might have been a row count function or something...

If a loop is the way to go I can do that easy enough 🙂

[laserlight]

Are you confusing a database with a database table?

A database consists of a number of tables.
Tables consist of a number of rows.

To count the number of rows in a given table, using PHP with mysql, we can use something along the lines of:

$query = mysql_query("SELECT fieldname FROM tablename");
$num_rows = mysql_num_rows($query);

[fean0r]

Thanks thats what I was looking for, sorry for my bad explanation!