0

i have an table in which certain columns are there i want to edit the data whenever i click on the button in front of a that particular row

4
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by seslie
0

You have to have a unique identifier on the row from the Database.
Then you have to get the data from the DB on click into a form to edit it.
Then all you have to to is to update the DB with your new values, if there are new values.

0

Hi shwetaaroa,

in addition to above.

You'd implement the button function on the front end of your application . At the database end, you'd need to connect to your database and update your table by using an sql upadte query syntax:

UPDATE [table_name]
SET [column_name] = value, [column_name2] = value2,..
WHERE [_column_name] = _value

The words in braces are variables, i.e they depend on your own values. I assume you're familiar with simple SQL operations too. If not, no worries, they're quite easy to learn. A number of sites are available on the net. Check out w3schools.com as a starter.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.