PHP MYSQL Table help

Ok so i have a database with a table users. The users each have a
unique id. Now i want to create another table called profile where the
users can edit their profile and it will be stored in the profile
table. But i need to somehow connect the tables together so when the
user saves itll save the information in the table profile under their
id that they have in the users table.

Help!

re: PHP MYSQL Table help

Dave wrote:Select *from profile, user where profile.user=$userid

update profile set () where profile,.user=$userid.

re: PHP MYSQL Table help

Dave wrote:Another suggestion is to get a copy of MS Access. It has a good
graphical query builder. After you build the query, look at the SQL
statement. You can learn a lot that way in the beginning stages of
learning SQL.

re: PHP MYSQL Table help

The Natural Philosopher wrote:No comma before the .user (we all make typos)

re: PHP MYSQL Table help

Thanks for the help!