Very Basic Question

techgearfree

I have a table called users. There are Different columns, but to simplify this, lets say there is just Username, Password, and Login times Collumns.

When someone signs up, there username goes into the username collumn, and password goes into password collumn. Now when they sign in, the time goes into the Login Time collumn using this:

$time = time();

$logintime = "UPDATE users SET time='$time' WHERE username='$username'";

Now, when someone logs in, it overwrites the previous value in the collumn.

How can I get it to keep the old one, and add a new time so I have a complete list of times they log in?

Thank you

bastien

store that in another table

table strcuture

Login_history
record_id
user_id
login_time

techgearfree

2 ?'s:

1.) Why can't I just use the current table?

2.) How do I add a collumn to an existing table?

Thanks

bastien

You can't use the existing column (table) because every time your user logs in you want to track it...that would mean you would need to add a column every time the user logs in...gets way to screwy when trying to do it like that and there is a column limit per table. From a pure design point of view that kind of structure makes no sense. You could never query cleanly from this table and any reporting done from this table would be useless from an analysis point of view

alter table tablename add column column_name (properties)

read the mysql manual for more info

Roger_Ramjet

techfreegear can you please not cross post the same quetion in several forums. If you don't know better then you have not read the forum rules. It's just basic netiquete really.