Need help creating an editable table

[jin]

hi guys,

I need to represent my database as an editable table so that you can edit multiple entries and the upload once to the database, rather than editing one row at a time. So what i have right now is something like this where the table is just displayed as text the edit is link to take you to a page to edit the row.

code:

a  b  c 1    1a      edit 2     2b     edit 3         3c edit

What i am looking to do is be able to edit the table all at once then then only have one link to save changes in the database.

code:

a    b    c    Update database 1    1a 2        2b 3             3c

I have only started learning with html, php and mysql. If it can be done using those great, if not please let me know what i should be looking into and if you know of any good tutorials.

Thanks