Update Database

I'm trying to build a front-end for my database, I've got it to display the data from the database in input fields and I have put an 'Update' button next to each input field. I want to be able to edit any of these fields and then clicking on its corresponding 'Update' button should update that field only in the database.

How do I go about doing this?

 

I would suggest you not re-invent the wheel, use phpmyadmin.

 

OK but this is also going to be a customer front end too, I would like to them to log in and update their details in the database.

 

use a query something like:
UPDATE tablename SET fieldname1 = value, fieldname2 = value2 WHERE id = recordnumber

 

write the update script so it accepts an argument/parameter in the url like update.php?id=0009 with the rest of the information. That would use GET method. If you wanted to use POST (to keep the data secure), you would have to generate a form for each row of data.

 

This is your solution Updating Records using php

 

mrmaf - thanks but that's updating the whole row if if you only edit one field - what if i want to update just that one field in the row?