[SOLVED] RecordCount in ASP-MySQL

Monie · #1 (**permalink**) Oct 31st, 2007, 07:48

I know how to do a RecordCount (count the total record in my database table) in MS Access, since I am new to MySQL, could anybody suggest me a better way than what I have found in the Internet? Thanks..

Here is the code that I am using right now:

Code: Select all

<%
    Dim connString, cp, conn, rec,count
    connString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=monieweb; OPTION=4; UID=root; PASSWORD=monie;"
    Set conn = Server.CreateObject("ADODB.Connection")
    Set cp=Server.CreateObject("ADODB.Recordset") 
    conn.Open(connString)
    Set cp = conn.Execute("SELECT * FROM userlogin")
%>
<%    
    'RecordCount
    Dim intRows
    Function RecCount(cp)
    intRows = cp.GetRows
    cp.MoveFirst
    RecCount = UBound(intRows,2) + 1
    End Function 
%>

<body>
<% Response.Write (" Total Record: " & RecCount(cp) & "")%>
</body>

Monie · #2 (**permalink**) Nov 1st, 2007, 06:59

Found a better way to do it:

rsCount is your recordset

HTML: Select all

Dim count, totalUser
While Not rsCount.EOF
count = count + 1
rsCount.MoveNext
Wend
    
totalUser = count

<%Response.Write("Total User : " & totalUser & "")%>

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] do I need mysql set up on my computer?	Oak	Databases	7	Jan 18th, 2008 14:27
[SOLVED] XML > MySQL?	alexgeek	PHP Forum	13	Jan 5th, 2008 10:45
[SOLVED] Connecting/Using MySQL and ASP	Monie	Classic ASP	8	Oct 12th, 2007 09:00
[SOLVED] MySQL to MSSQL	Anonymous User	Databases	7	Oct 6th, 2003 07:48

		Webforumz.com > Main Forums > Program Your Website > Databases
[SOLVED] RecordCount in ASP-MySQL