[SOLVED] Msql Count function in a php form

[gavenf]

I want to show the numebr of rows listed in a specific table.  The number needs to be visable each time the page loads automatically.

 

The table is called registered

The db is called circusart

 

Thanks

[trq]

SELECT COUNT(*) AS totalrows FROM registered;

[cooldude832]

for better optimization don't use star, but a boolean based table variable or ID

[teng84]

ya use the primary key

 

ASTIG!!!

[gavenf]

ya use the primary key

 

ASTIG!!!

 

You say to use a primary key so should it read

 

SELECT COUNT(id) AS totalrows FROM registered;

 

Also do I jsut put his straight into my php page where I want it to appear?  Does it work the same for html pages?

Do I need to connect tot he db at the very top of the php page first or can it be done in the same spot?

[teng84]

you still have to connect from db

 

mysql_connect('your host','userhere','pword here if any');

 

mysql_seect_db('your db name');

$result=mysql_query('SELECT COUNT(id) AS totalrows FROM registered');

 

$row=mysql_fetch_assoc($result);

echo $row[totalrows];//display the num rows

 

or you can have this

echo mysql_num_rows($result);//display num rows