ASP source code, need to display the category name on the content page, how to call and write the code?

SQL = " select * from Show where tid = " & amp； Id & or tid in (choose ID from Show_Pro, where pid = "& ampid & amp") is sorted by id desc ".

SQL 2 = " select * from Show _ Pro where id = " & amp； Identification (identification)

SQL 3 = " select title from show _ pro where id =(select tid from show where id = " & amp； id & amp")"

set rs 1=conn.execute(sql3)

If it is not rs 1.eof, then

menuname=rs 1("title ")

other

Menuname= "There is no such classification"

If ... it will be over.