ASP - get number of records in a table? - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

ez2c · 08-19-2005, 06:00 PM

Hello,

Are there other way's to get the number of records in a table other then:

PHP Code:


		
			
<?php BEGIN__VBULLETIN__CODE__SNIPPET <%

rs.Open "Select * From tablename ",conn, 1, 1

response.write rs.recordcount

%>

thanks

clifford · 08-20-2005, 05:32 PM

How about using sql statement :

select count(*) from table_name