Weird MYSQL stuff ...

[TJK]

I'm creating the backend of our local club and I'm using PHP to send and retrieve data from the server. However, I ran into weird stuff lately. Well, in the database I have the table members and is created like this:

Code: Select all

$members_sql = "CREATE TABLE members (
ID INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(100) NOT NULL,
Email VARCHAR(100) NOT NULL,
Telephone VARCHAR(100) NOT NULL,
Cell VARCHAR(100) NOT NULL,
Home VARCHAR(100) NOT NULL,
TIN VARCHAR(100) NOT NULL,
MSCode VARCHAR(100) NOT NULL,
Status VARCHAR(100) NOT NULL,
Job VARCHAR(100) NOT NULL,
Reg_Date TIMESTAMP,
GDPR VARCHAR(100) NOT NULL,
SMS VARCHAR(100) NOT NULL,
MAILTO VARCHAR(100) NOT NULL,
)";

I went on to alter the table to add a column Expire that basically adds the expire date of the membership of the member. It increments the REG_DATE column by 1 year. So far so good , the table has been altered , the column has been added. However, the REG_DATE has also been altered and now displays the current date instead of the actual date that the registration took place.

Is this normal or am I missing something? The site is still in beta mode and no-one will notice it but out of curiosity. How do you normally alter tables?

P.S: This is not a support question. Just asking if this is the intended behaviour and how you guys go altering tables using PHP .

[david63]

Is this phpBB related?

[TJK]

No, David! This is not phpbb and I just realised that I posted it in the wrong forum. It should have been at "General Discussion". I'm just asking it for my personal curiosity.

[Lumpy Burgertushie]

you would be better off at a support site for php and /or mysql.

luck,
robert

[TJK]

Hi Robert,

as I said it the first message this is not a support question. I'm just asking if someone has seen this before and if he/she knows if this is the intended behaviour. Other than that, I'll go down this path since the site is not online so no-one will bother.

[david63]

Did you consider doing a Google search on "mysql timestamp behaviour"?

If you did you would find that depending on how you have your table set up it enters the current date/time

[TJK]

Hi David,

I did actually but probably with the wrong key words. Anyway, thanks for sharing ! Consider my question answered!