[Newtonhead1]

Hi Eikinskjaldi,

I sincerely appreciate your input. Due to my obvious concern to get the syntax of the query exactly correct, would the following be in correct format?

update post set threadid=NEW thread id where threadid=OLD thread id and dateline between (unix_timestamp(start_date), unix_timestamp(end_date))

Sample:

update post set threadid=123456 where threadid=654321 and dateline between (unix_timestamp(2006-01-01), unix_timestamp(2006-12-31))

Am I missing any apostrophes or commas in the above? For example...

update post set threadid='123456' where threadid='654321' and dateline between (unix_timestamp('2006-01-01'), unix_timestamp('2006-12-31'))

Am I missing any formatting requirements, especially in the date formats?

FYI, I am planning to test this on a test forum before I run it on my production forum.

Thanks,

Newtonhead1