CODEWITHSUNDEEP
phpdatabase
user1092042
user1092042

Reputation: 1295

Refresh values in a database

I am really new to database management. I installed wamp and have set up a database in phpmyadmin. Now I need to refresh the value of a particular row which contains some data. How do I do this. Are there any good tutorials for doing this available on the net. Can you please point me in the right direction as I don't know what to do now.

Upvotes: 0

Views: 72

Answers (2)

Ramon Araujo
Ramon Araujo

Reputation: 1738

I think you are referring to the visual thing more than what is happening on the background. If you hit the button, lets say, update, the page will go to the server and come back with the new, updated results of what you are trying to update. Before digging into using complicated techniques to make this happen nicely, try to understand the page lifecycle. Then start applying javascript(and AJAX) if you want to make this happen nicely. Hope this helps,

Upvotes: 1

DanRedux
DanRedux

Reputation: 9359

It's called "UPDATE".

mysql_query("UPDATE table_name SET field_name = new_value");

If you add a condition to the end, you can decide which record get's updated.. Assuming you have an "id" field (which is unique to each record), you could change the record with ID 50 by appending:

where id = 50

to the query.

Upvotes: 1

Related Questions