UPDATE multiple rows with loop
Posted on 2006-11-14
I have the table 'addr_im' that was altered by Adding a datetime field called 'date_create'.
There are 1753 rows
I need to populate the 'date_create 'with a random Date in the last month
USING THIS FRO THE RANDOM DATE
$ranDate = date('Y/m/d h:m:s', mktime(rand(0,24),rand(0,60),rand(0,60),10,rand(1,30),2006));
I need to loop through each row and update 'date_create' with $ranDate