Originally Posted by hosam
well I have this table `massages` and have these rows:
so if I want just to update the date2 with php what I should then insert inside SQL query?
No. you have a table with those columns
(also known as fields
). You might have *MANY* rows
(also known as records
), each with a different id, title, message, etc.
To change just one field in one record, you would do something like
UPDATE message SET date2 = '2012-2-18' WHERE id = 17
You would, of course, use the date you really want and the id you really want.