<cfquery name="add_hit" datasource="stoneleigh_hits">
INSERT INTO stoneleigh_hits (page_name,hit_date)
VALUES ('index.cfm',#now()#)
</cfquery>
^^^ i put this on every page
<cfquery name="display_hits" datasource="stoneleigh_hits">
SELECT * FROM stoneleigh_hits
</cfquery>
<cfquery name="index_hits" dbtype="query">
SELECT * FROM display_hits WHERE page_name LIKE 'index.cfm'
</cfquery>
^^^ and this on the hit counter display page
<cfoutput>#index_hits.recordcount#</cfoutput> and this in the table cell.
it was a lot easier than i first thought. thanks again
James
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
