i have userid which is the primary key in members and is a foreign key in booking

i have movieID which is a primary key in movie and a foreign key in booking

and the rest the values i wanna put in booking table Showing num, credit card, expiry num

the problem i m having is that the user types there name in a txt box types which then matches the userid with username in memeber and then saves puts userid in booking.

the same thing for movieid..user picks movie, movie name gets matched to movie id in movie table and then movie id is put in booking table

and the rest of the values that are in the txt box Showing num, credit card, expiry num get put in booking table as well...! the problem im having is i keep getting wrong syntax..! this the only problem i have and then i ve finished, could neone help me plz plz