Hi...
Iam creating a database for the music club I belong to. "PHP +MYSQL" Ive studied databases but I have problems with the implementation.

I have two tables one called users with a uid as a primary key. And another table called schedule with sched_id as the primary key.

The registration input form contains a a schedule through which the user can choose his schedule...and he has to enter email address etc..

Then I do the following:

$sql= "INSERT INTO users(name,major,phone,email,address,instrument) ".
"VALUES('$name','$major','$phone','$email','$address','$instrument')";
@mysql_query($sql) or die(mysql_error());

The question is : Now that Ive entered the data for the user how do I insert his schedule in a manner that links them together. Ive added "uid" the primary key of the user table to the schedule table.

If you have the schedules primary key in the users table, then it links them together, i.e.

users
-----
uid (primary key)
sched_id (foreign key)
etc...

Then when you create a schedule for a user, you insert its primary key in the relevant user's record. Then when you select * from users where sched_id = some_value and uid = your_user, you will get the users data for the schedule, or if you have a user, first get the schedule id from the user table then search the schedule table for that id. Im not so good with SQL syntax but hope you get the idea

I think theres a JOIN function of SQL that might help in doing what you want? As i always say, google it