Count Database entrys with cfm 1

[noellees1]

Hi, ive setup a database with a datasource etc i want it so when people enter into that database on a main page you can make a script which counts the ammount of users registerd. getting me so far?

all i can say is im quite new to cfm and just want a way to count records in a database so that itle display as a number how many users have been made.
an examble would be brilliant.
thanks
N lees

Hope this helps,

http://www.spano.co.uk

http://www.spanoweb.com

http://www.stowrepair.co.uk

http://www.radiostow.co.uk

http://www.stuckforhosting.co.uk

 

[boatguy]

I am just a newbie and I am sure someone here can give you better advice, but this should work.

<cfquery name="younameit" datasource="yourdatasource">
Select *
From your_table
</cfquery>

<cfset totalusers="younameit.recordcount">

Total Users:<cfoutput>#totalusers#</cfoutput>

 

[ecobb]

Try this:

<cfquery name="younameit" datasource="yourdatasource">
Select Count(*) AS Records
From your_table
</cfquery>

<cfoutput query="younameit"> There are #Records# records in the database</cfoutput>

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

 

[noellees1]

thanks guys it works thanks for your help

Hope this helps,

http://www.spano.co.uk

http://www.spanoweb.com

http://www.stowrepair.co.uk

http://www.radiostow.co.uk

http://www.stuckforhosting.co.uk