Editing Table data

Is there any way to change some of the values inside a table without replacing all of the information. For instance if a price changes on one item, can I change that one field using PHP and MySQL or do I rewrite the text file and replace the whole thing? Thanks for the help.

Hi,

you can change a field value with out changing all the values in a table.

Just use an update statement for getting this.

"UPDATE TABLE TABLENAME SET PRICE=1000 WHERE ITEM='item1'";