<%
DIM mySQL, objRS
mySQL = "SELECT Count(*) AS trip_id FROM trip_master"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open recSQL, objConn

' Display result
Response.Write objRS("trip_id")

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>


should my code above output the number of rows in my mysql db. table name = trip_master and column name = trip_id???

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

<%
DIM mySQL, objRS
mySQL = "SELECT * FROM trip_master"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, objConn

' Count how many records exist
DIM iRecordCount
iRecordCount = 0
DO WHILE NOT objRS.EOF
iRecordCount = iRecordCount + 1
objRS.MoveNext
Loop

' Display result
Response.Write "(" & iRecordCount & ")"

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing

%>


crashes my DB