noob question - updating records

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
irealms
Forum Contributor
Posts: 215
Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds

noob question - updating records

Post by irealms »

i want my change password form to update the record when the users has filled in the form correctly, whats the MySQL command for this?
User avatar
Heavy
Forum Contributor
Posts: 478
Joined: Sun Sep 22, 2002 7:36 am
Location: Viksjöfors, Hälsingland, Sweden
Contact:

Post by Heavy »

User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

You would use an UPDATE statement to make a change to an existing record - check out:
http://www.mysql.com/doc/en/UPDATE.html

Mac
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

You should probably give a quick reason as to why you posted a link to a resource like this, I agree that it is something that people should read but I don't like to see it being posted with no explanation attached.

Mac
User avatar
Heavy
Forum Contributor
Posts: 478
Joined: Sun Sep 22, 2002 7:36 am
Location: Viksjöfors, Hälsingland, Sweden
Contact:

Post by Heavy »

Yeah... I'll never grow up. :oops: Guess I was in an immature mode at that moment. :oops:
Post Reply