Count entries on menu page

Hi,
you need to modify menu.asp file.

Here is an example:

<%

Add this string to menu.asp file:

<!--#include file="include/..._dbconnection.asp"-->

Thank you,
The code works correctly, but now I need the result of the count to give a result based on the session userid
Example
I start the session with the user id = John

I want the count to correspond only to his records

and the count result be placed next to the item in the menu generated by ASPrunner
Code example
Call GetTables(Session("UserID"))
if InArray("dbo.AGREGARV") then
Response.Write "<a href=""AGREGARV_list.asp"">SOLICITAR VIATICOS</a>
"

end if
*how can I place the count result next to SOLICITAR VIATICOS

Hi,
here is an updated code snippet:

<%

Change code in bold to match actual table/field names.

Thanks again it works great, one last question
In the code that you sent me, you specified the variable
Set rs = server.CreateObject ("ADODB.Recordset")
with this I can put in my web page <%=rs(0)%> and get the result of the count records statement.
I need this result to go next to the corresponding link of the menu that is generated by Asprunner.
Example code generated by ASPrunner
Dim arr
Call GetTables(Session("UserID"))
if InArray("dbo.AGREGARV") then

Response.Write "<a href=""CARS_list.asp"">CARS</a>
"

end if
I want the count result <%=rs(0)%> to be displayed next to "">CARS</a>
So when I display the web page I get
CARS 5 (where 5 is the result of the count)
Sorry for so many questions but I cant get it to display the count in the menu I can get it to work in any other part of the web page but not here.

Hi,
here is an updated code snippet:

Dim arr