Array Help

robh76

I need to know how to use PHP to step (one by one) through the records of MySQL database query result.

I am able to connect to the DB and perform a query. I am able to print the results of the query for the ENTIRE query result.

What I need now is to be able to view the query results one record at a time and cycle (step) through the records by using a control (button or link) on the page itself. (The first record of the query result displayed on page entry, a "next" link/button to see the next row of information).

Any directions would be greatly appreciated. Thank you.

thorpe

Search the board or google for pagination.

ezekiel

I don't know if this is the most efficient or best way to do it, but if you were to put your results into an array then store that array as a session variable you could page through them like you're asking. Then again you could use a limit,offset and just the query for each back/forward search. I don't know what your query looks like so I don't know which method would be better.

Piranha

I made an answer here, but since you posted in lots of forums I don't see a reason to give you that answer. Next time post in one forum and I'm sure that you will get a good answer.

Piranha

I don't get why you post this on so many subforums. It only make the persons that answer (I as an example) getting irritated and not wanting to help.

Sorry if this is spam, if an admin thinks so please delete the post.

Weedpacket

Threads merged and duplicates deleted. (See the guidelines).