$_SESSION['search'] = "true"; $grooupno = $_POST['gr0upno']; $_SESSION['grooupno'] = $grooupno; $day = $_POST['d4y']; $_SESSION['search_trans_day']= $day; $month = $_POST['m0nth']; $_SESSION['search_trans_month']=$month; $year = $_POST['y34r']; $_SESSION['search_trans_year']=$year; $deppdate = $year."-".$month."-".$day; $_SESSION['old_deppoint'] = ''; $_SESSION['old_destination'] = ''; $_SESSION['old_otherloc'] =''; $_SESSION['old_otherdest'] =''; $query22 = "SELECT vid, groupno, leadername, leadermobile, depdate, deptime, deppoint, "; $query22 .= "pax, leaders, destination, rettime, returnfrom, returnto, updated, "; $query22 .= "updatedby, active FROM boat WHERE groupno='$grooupno' AND depdate = '$deppdate' AND active='1'"; $result22 = mysql_query($query22); if (!$result22) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query22; die($message); } $rest = mysql_fetch_array($result22); print_r ($rest); while ($row = mysql_fetch_assoc($result22)) { $_SESSION['old_vid'] = $row['vid']; $_SESSION['old_groupno'] = $row['groupno']; $_SESSION['old_leadername'] = $row['leadername']; $_SESSION['old_leadermobile'] = $row['leadermobile']; $_SESSION['old_depdate'] = $row['depdate']; $depdate = $_SESSION['old_depdate']; list($year,$month,$day) = explode('-',$depdate); //echo "~~~~~~~~~~~~~~~~~~~~~>YEAR : $year"; $_SESSION['old_yr'] = $year; $_SESSION['old_month'] = $month; $_SESSION['old_day'] = $day; $_SESSION['old_gurnata'] = date("l",strtotime($depdate)); $_SESSION['old_deptime'] = $row['deptime']; list($hour,$min,$sec) = explode(':',$_SESSION['old_deptime']); $_SESSION['old_hr'] = $hour; $_SESSION['old_min'] = $min; $_SESSION['old_deppoint'] = $row['deppoint']; $_SESSION['old_pax'] = $row['pax']; $_SESSION['old_leaders'] = $row['leaders']; $_SESSION['old_destination'] = $row['destination']; $_SESSION['old_rettime'] = $row['rettime']; $deptime = $_SESSION['old_rettime']; list($hr,$mn,$sc) = explode(':',$deptime); $_SESSION['old_hr1'] = $hr; $_SESSION['old_min1'] = $mn; $_SESSION['old_returnfrom'] = $row['returnfrom']; $_SESSION['old_returnto'] = $row['returnto']; } print_r ($_SESSION); include_once 'menu_html.php'; ini_set("display_errors","On"); redraw_boat(); }