Best way to check for end of a record and send it back to the first record

Posted on 16th Feb 2014 07:03 pm by admin

I'm hoping someone can help me out and explain the best way to accomplish this.

What I'm doing I'm pulling data from a data base. I display the information 1 item at a time then have a next and previous link to navigate forward or backward through the records.

The issue is when it gets to the last record and I press the next link i get errors cause their is no more records. so what I'm wondering what a good way to send it back to the first record? would it make sense to store the total number of records in a variable and then load the load the id's pulled from the database into an array and check against the end of the array for the end of the records and send it back to the first element of the array?

Any explanations are examples would be helpful even a link to somewhere showing this would be good. I haven't found one yet.

Your Answer:

Login to answer

Other forums

foreach result into a single variable
Hi,

I have this code...

Code: [Select]foreach ($_POST['Interests'] as $interest =&

array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an e

Typedef struct vs just struct
Anyone know the rationale for using typedef for structs when a struct is itself a typedef? I have s

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s

ereg_replace issue
hi there people

i have this code happening with regards to my wamp server. is this something

php mysql query from input textbox
Hi,

I have a text box, in that i have given the mysql query. I can able to get the query in v

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Drawing Images in classes
I'm quite new to Object Oriented PHP. What I'm trying to do is draw some images but also have other

Grouping and sorting results
Please help with this query.

I have 2 tables in a database, countires and cities. states look