i need help with a global db change

[Preech]

I want to update my membertable with my sites reopening date as the join date for all my members. So basically the site has been closed for 3 months and i deleted all the old posts....i just want to update that so that all the old memberlists carried over have the reopening date as the join date, 4000 members would be a little much to do by hand

i run vb3.0 by the way if that makes any diff with the command structure

please help

[Christine]

What date and time do you want it to say?

[Preech]

02-18-2004 100 am

please

[Christine]

On one condition -- you back up your database before running this script!



UPDATE user SET joindate='1077084000';

[Preech]

that will update all eh? ok thanks will do backup.

[Christine]

Yes it will. Just copy it and paste it as I have it written and run it in phpMyAdmin on your user table.

[Boofo]

Christine, how did you come up with the date like that? Please PM me the answer.

[Christine]

Bob,

I am Rainman.

[Boofo]

Lol