How to make foreign key linking in INSERT statement?

[vinceboy]

Hey..guys! I have INSERTstatement here which have two foreign keys that need to refer to other tables.How can I achieve it?

$sql = sprintf("INSERT INTO `reserve` (`reserve_datetime`, `seat_qty`, `ref_code`, `movie_id`, `member_id`) VALUES ('%s', '%s', '%s', '1', '1')", $date, $noOfSeat, $refCode);

movie_id and member_id are foreign keys that linked to movie and member tables respectively.Th anks for your help..

[vinceboy]

If I refer member_id as below, the INSERT statement can't work.....

$foreign1 = "SELECT member_id FROM member WHERE   email = \"" . $_SESSION['gmemberid'] . "\" "; 

  $sql = sprintf("INSERT INTO `reserve` (`reserve_datetime`, `seat_qty`, `ref_code`, `movie_id`, `member_id`) VALUES ('%s', '%s', '%s', '1', '$foreign1')",  $date, $noOfSeat, $refCode); 
 mysql_query($sql);