update date

[dirkadirka]

probably a very silly question but I need to have a form button globally update the date within an entire table.

basically when I hit confirm I want every records date to be updated to the current date.

$date = date("YmdHis");
$updateSQL = "UPDATE currentjobs SET DATE_POSTED $date";

Im doing something like this but its not working, reading the mysql site it said update would update every record if you did not specify a WHERE clause so I'm guessing I'm just retarded for some other reason 😕

I was under the assumption that the update function in its own way is a while loop already and by not including the WHERE clause I could update every record, if this is not the case I suppose I have to manually set up a while or foreach statement to go through each record then update them?

thanks for any help guys.

[xblue]

I think your query is missing the equal sign after DATE_POSTED. Normally I would expect this to result in an error, so if you should not receive an error you should make sure that you did not accidently forget to execute the query.

BTW when working with datetime columns, you could as well use NOW() right in the query instead of creating the date with php.

[dirkadirka]

Could you explain how the NOW() would work in this situation?

Still can't get this to work.

[dirkadirka]

meh, i got it to work sorta, its a problem with the form action...not sure what I'm doing wrong with that part...once I took the action out and just had the page process the update it worked.