I have two table(both in the same database)

tblupdates
updateID(autonumber), upuser, uptitle, upinfo

userlist
username, avatar, password


Then a script that displays the updates.

How can it look at the upuser, then go into the other table, find a username that matches, then response.write the avatar?

Select username, avatar from userlist inner join tblupdates on upuser = username

You can add whatever you'd like in a where clause to limit to a specific date, title, or whatever. But rather than creating a routine in your asp code that looks over both tables, let the database do the matching work it's good at. Like Microsoft says, "move the logic to the data, don't move the data to the logic."

If you're trying to build a very high scale application, you might need to cache it, but most of the time you want to delegate to the database.

<%@ Language=VBScript%>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("datab/db1.mdb")
Conn.Open

Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "SELECT * FROM tblUpdates ORDER BY updatesID DESC inner join tblupdates on upuser = username", Conn, 1,3

rs.MoveFirst

Response.Write rs("upuser")& ":  " & rs("uptitle") & "<br>" & rs("upinfo") & "<br><BR>"
rs.MoveNext
Response.Write rs("upuser")& ":  " & rs("uptitle") & "<br>" & rs("upinfo") & "<br><BR>"
rs.MoveNext
Response.Write rs("upuser")& ":  " & rs("uptitle") & "<br>" & rs("upinfo") & "<br><BR>"
rs.MoveNext
Response.Write rs("upuser")& ":  " & rs("uptitle") & "<br>" & rs("upinfo") & "<br><BR>"
rs.MoveNext

set Rs = nothing
set Conn = nothing


%>

thats my code.

how do i write the avatar depending on who the user is?

rs("avatar_column") inserted into a <img> element? more info on the table structure would help

"ORDER BY criteria" should be last in the SQL statement.

don't use "SELECT * FROM" it is very inefficient

skeddles,

Can't resist to notice this bug:

Rs.Open "SELECT * FROM tblUpdates ORDER BY updatesID DESC inner join tblupdates on upuser = username", Conn, 1,3

Changed to:

Rs.Open "SELECT * FROM tblUpdates inner join userlist on upuser = username ORDER BY updatesID DESC", Conn, 1,3

Avoid select (*) like chris mentioned, use the needed column names in select query.