cycle through mysql table data
Posted: Tue Apr 06, 2010 10:34 am
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.
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.