How do I show how many rows in my database?

[jfleck25]

I am working on a social network and want to know what I need to do to show on my homepage how many users (rows) I have in my database.

[Weedpacket]

Count the number of rows in the database table and show that.

[jfleck25]

I want it to be automatic so each time someone signs up the number automatically increases

[traq]

jfleck25;11031477 wrote:

I want it to be automatic so each time someone signs up the number automatically increases

Right.

Weedpacket;11031475 wrote:

Count the number of rows in the database table and show that.

like

SELECT COUNT(*) number_of_users FROM user_table