i need help with a global db change
 

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 :)

What date and time do you want it to say?

02-18-2004 100 am

please :)

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

:)

UPDATE user SET joindate='1077084000';

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

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

:)

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

Bob,

I am Rainman.

:)

Lol ;)