Page 1 of 1

cycle through mysql table data

Posted: Tue Apr 06, 2010 10:34 am
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.

Re: cycle through mysql table data

Posted: Tue Apr 06, 2010 10:59 am
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".

Re: cycle through mysql table data

Posted: Tue Apr 06, 2010 5:43 pm
by sirk
ah cool thanks for the jump off point really was clueless as to waht it was called