How does the UPDATE statement work

[scooterlibby]

I have found that the tutorial I was using and basing my UPDATE statement does not work and the answers I have gotto so far, I am sorry to say, I do not understand. I have a number of PHP books available to me but they skirt over the update issue

 

So please anyone could you point me to a tutorial  where I can select a simple record from a file display the fields and update the file with any modifications.

 

I have mastered the select and display  just the UPDATE has me confluxed. :'(

 

Regards

Scooter

[per1os]

http://www.tizag.com/mysqlTutorial/mysqlupdate.php

 

What is there to know about the update statement

 

To updated 2 columns for specific records

UPDATE table_name SET column_name = 'value', column_name2 = 'value2' WHERE column_name3 = 'value3';

 

Or to update 1 col for specific records:

 

UPDATE table_name SET column_name = 'value' WHERE column_name3 = 'value3';

 

Or to update every record in the table

UPDATE table_name SET column_name = 'value';

 

That is that, nothing more.