[Stulie]

Hi I am going to do my best to explain the problem. I am fairly new to using ASP and I am pretty well teaching myself so bare with me.

Issue: I have created a website for a car lot. All of the information for the vehicles are submitted using a form and added to a database created with Access. Currently when you go to thier website and check thier inventory, the database gets queried, an image and some basic information loads to a simple table. As the query finds another car it loops and loads a new table on the page. Everything here is working as it should but now that thier inventory is growing, you have to scroll further than the client would like to see. The client now would like the page to show only a certain number of vehicles per page then you would have to click 'Next' or a page number to view the next page of vehicles. How can you go about only querying a certain number of items then creating a new page. It would have to auto create the page number on the web site and when going between pages not seeing the same vehicle twice.

I hope my question is understood and I thank anyone in advance who is able to assist.

Thanks, Steve V.

several things

1. if you can do not use access....it can prove to be problematic down the road.
2. use select *,(select count(*) from same_table where this = that) as record_count from table where this = that limit (start, end)
3. then based on the record count create next and previous buttons, and fill in the limit portion of sql

[Stulie]

Tnx Koncept....unfortunately I don't understand enough about ASP to get what you are saying....lol.

I found this today.

http://www.codefixer.com/codesnippet...dsetpaging.asp

This code, although quite lengthy actually works very well. I posts everything from the database and leaves the connection open to post the next results without repeating any more than once. It also automatically shows the page numbers at the bottom the way I wanted. Only 1 thing I need it to do but I am not shure how to. That current code only will only list vertically. What I need it to do is list the results horizontal for 3 listings then drop to the next line for 3 more. What I need is 3 rows of 3, then have it make a new page.

Tnx in advance,
Steve

to build a 3 by 3 grid is easy enough to do...

Code:

 	  <td><div align="center"><a href="ipics.asp?fold=<%=request.QueryString("fold")%>&pic=<%=file.name%>"><img src="<%=request.QueryString("fold") & "/" & file.name%>" width="130"  height="130" border="0"></a></div></td>
 <%
 	  intpiccounter = intpiccounter + 1
 	  if intpiccounter = intpicsperrow then
 %>
   </tr><tr>
 <%
 		intpiccounter = 0
 	  end if

edit: you will need to have a table around parts of this

it will replace these lines from the example

Code:

                  response.write "ID: " & Recordset ("ID") & "<br>"
  response.write "Sitename: " & Recordset ("Sitename") & "<br>"
  response.write "URL: " & Recordset ("URL") & "<br><br>"