Quote:
Originally Posted by hosam
well I have this table `massages` and have these rows:
id
title
message
date1
date2
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
Code:
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.