Copy field from one table field to another table field using key-convert date

[tyler_durden]

This is my first real jump into PHP, I created a small script a few years ago but have not touched it since (or any other programming for that matter), so I'm not sure how to start this.

 

I need a script that I can run once a day through cron and take the date from one table/filed and insert it into a different table/field, converting the human readable date to a Unix date.

 

Table Name: Ads

Field: endtime_value (human readable date)

 

to

 

Table Name: Node

Field: auto_expire (Converted to Unix time)

 

Both use a field named "nid" as the key field, so the fields should match each nid field from one table to the next.  Following a tutorial I have been able to insert into a field certain data, but I don't know how to do it so the nid's match and how to convert the human readable date to Unix time.  Thanks in advance!.

 

 

[tyler_durden]

Doh!  I was floating around the forums before posting this and thought I was in the "PHP Coding Help" forum.  I am going to repost this since it looks like I cannot move the post.  Sorry...