How do I edit a single row of a column in a database?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
xenoalien
Forum Newbie
Posts: 19
Joined: Fri Apr 04, 2008 12:11 pm
Location: Cyberspace

How do I edit a single row of a column in a database?

Post by xenoalien »

How do I edit a single row of a column in a database? In some sense, I would like to be about to change or replace a cell within a database table. How would I do this? I understand how to INSERT and get data from a database table but I do not know how to replace.
User avatar
flying_circus
Forum Regular
Posts: 732
Joined: Wed Mar 05, 2008 10:23 pm
Location: Sunriver, OR

Re: How do I edit a single row of a column in a database?

Post by flying_circus »

The SQL command is UPDATE

UPDATE myTable SET myValue='updatedValue' WHERE myColId = 'myId';
xenoalien
Forum Newbie
Posts: 19
Joined: Fri Apr 04, 2008 12:11 pm
Location: Cyberspace

Re: How do I edit a single row of a column in a database?

Post by xenoalien »

Thanks man! I am trying to make a submission form and database for my school for track and field sports. For other school to submit their participants for events and meets.
Post Reply