how can i skip to the next user?

When you open the recordset use the SQL statement

SELECT * FROM yourfield
FROM yourtable
ORDER BY yourfield asc

not totally positive on my coding but you should get the basic idea... this will order 'yourfield' from 'yourtable' into ascending alphabetical order. now you can use the following HTML statement to move to the next name in the list.

<a href="<%rs.movenext%>">Next name</a>

now, this tells the computer to move to the next record and since they're ordered in alphabetical it moves to the next record. This link needs to be on the same page as the opening calls for the database and sql statement. Something like this

'open your database
'recordset opening call
'html beginning
'your link
'html ending

hope i helped...

Paul Morgan
Webmaster

no problem- the only problem with using a "WHERE" clause is that it only selects what it equals. For example: If you have several records, lastnames (to make it easy) 5, 4, 3, 2, and 1, and you use the line "SELECT * FROM yourtable WHERE lastname = 5" then it will only select 5. My suggestion, drop the where clause and only use select and order by. Try this,

"SELECT * FROM yourtable ORDER BY lastname"

then use the link i posted before to move to the next record.

Paul Morgan

when you select the fields and use a where clause it only selects what you specify in the where clause . for example: you have a table: with one field called 'I' (remember i'm making it simple) the values of i are 1, 2, 3, 4, 5, 6, 7, and 8. if you only select 5 then the computer doesn't worry about 1, 2, 3, 4, 6, 7, and 8. When open up a recordset your basically telling the computer with a WHERE clause that you only need 5. When you say 'rs.movenext' then you hit EOF and you get a falure. If it was imperitive that you start on 5 then you would say:

"SELECT * FROM yourtable"
rs.movefirst
loop = 5
While loop > 0
rs.movenext
Wend

this would take your record pointer and place it on the fifth one in order.