cycle through mysql table data

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
sirk
Forum Newbie
Posts: 15
Joined: Sat Apr 03, 2010 8:40 am

cycle through mysql table data

Post by sirk »

im a little bit unsure about how to go about this, but basically i have a database that records jobs, what i want to do is on page load display those jobs, then be able to have a button that can update the table if the user has edited any of the fields, then another set of buttons that can go back and forth data contained in the table (next record first record etc.)

the way i intend to display the data is by using textboxes, some arent going to be editable and some are, for example if the user has completed a job they have to state what they did etc and the new data needs to be added to updated in the database. the user is also going to need to be able to go to the next row of data sotred in the mysql table so they can cycle through all of their open jobs.

im not sure if a button is best for each of these tasks or not. like i said im not sure how to go about this so i dont have anycode yet other than the html for the form, so all ideas or resources are welcome. thank you very much in advanced.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: cycle through mysql table data

Post by Christopher »

You should search for "pagination" for going from one set of records the next. Search for "CRUD" for record editing. You might also want to search for "datagrid".
(#10850)
sirk
Forum Newbie
Posts: 15
Joined: Sat Apr 03, 2010 8:40 am

Re: cycle through mysql table data

Post by sirk »

ah cool thanks for the jump off point really was clueless as to waht it was called
Post Reply