Quote:
|
Originally Posted by Space Cowboy
um im getting confused in my users table i have id which is primary and auto increment and i can't have two. Should i create a new table called messages then, and add username, messageid and everything?
|
Oh HELL yes! You should create seperate tables for each major new feature that requires lots of new data fields - it keeps your tables much simpler that way. You can always pass variables between the tables using PHP - its dead easy really! Just think of it this way - your MessageID field will be the unique auto-incrementing one unique to this table, your sendingusername/receivingusername will relate to the member ID on the Users table.
Its all very logical - you just have to get your head around thinking in this way.