$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);

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

 <select name="rNumber" title="number of ticket">
                      <option selected>Select</option>
                      <option>01</option>

 function GoToNextPage(value){
        if(value != ""){

<select name="rNumber" title="number of ticket"
					 onChange="GoToNextPage(this.value)">
                      <option selected>Select</option>

<form action="" method="post" name="movieList" 
		  onSubmit="return validate(this);">

<script language="JavaScript" type="text/JavaScript">
    function validate(which) {
        var selects = which.getElementsByTagName('select');
        var radios = which.getElementsByTagName('input');

<script language="JavaScript" type="text/JavaScript">
function nullValidation() {
    var x=document.getElementById("movieList");
    for

<script language="JavaScript" type="text/JavaScript">
function formSubmit(ticket)
{
	var returnStatus = 1;

    if (ticket.rNumber.selectedIndex == 0){ 
		alert("Please select number of ticket!");

<script language="JavaScript" type="text/JavaScript">
function formSubmit(ticket)
{
	var returnStatus = 1;

    if (ticket.rNumber.selectedIndex == 0) { 
		alert("Please select number of ticket!");