I have a MySpace tracker, and i programmed it to work like this: Each user has their own table (and the table name being their username), then they have rows such as password (wich has their password in it) , and then they have their hit related rows (name, picture, URL, etc) ... I want to somehow reprogram it to where it will be devide it into 2 tables (one being hits, and anotherone being usernames).. the username table will have the rows username/password in it with all the usernames and passwords in the database... the hits table will have rows such as username (the username that the hit belongs to) , picture, url, name , etc.. anyone who is willing to help me with this would be greatly appreciated.
You want the 'username' table to contain a unique ID and all the username details (password, picture, url, ...) and then a smaller 'hits' table with the username ID as foreign key and a record for each hit Search the web for 'sql join' and 'sql foreign key', you might find something useful