query($querystr); if($db->num_rows()>0) { $db->next_record(); $stored_ship_dest_id = $db->record[ship_dest_id]; $stored_ship_port_id = $db->record[ship_port_id]; $stored_recp_name = $db->record[recipient_name]; $stored_recp_address = $db->record[recipient_address]; $stored_recp_state = $db->record[recipient_state]; $stored_recp_city = $db->record[recipient_city]; $stored_recp_zipcode = $db->record[recipient_zipcode]; $stored_recp_country_id = $db->record[recipient_country_id]; $stored_recp_tel = $db->record[recipient_telephone]; $stored_recp_fax = $db->record[recipient_fax]; $stored_recp_email = $db->record[recipient_email]; $curr_arrival_day = $db->record[arrival_day]; $curr_arrival_month = $db->record[arrival_month]; $curr_arrival_year = $db->record[arrival_year]; } else { print("No record found!"); } } else { #retreive the default setting of the user $querystr = "SELECT * FROM aqua_user WHERE user_id = '$cookie1'"; $db->query($querystr); if($db->num_rows()>0) { $db->next_record(); $stored_user_id = $db->record[user_id]; $stored_ship_dest_id = $db->record[ship_dest_id]; $stored_ship_port_id = $db->record[ship_port_id]; $stored_recp_name = $db->record[recipient_name]; $stored_recp_address = $db->record[recipient_address]; $stored_recp_state = $db->record[recipient_state]; $stored_recp_city = $db->record[recipient_city]; $stored_recp_zipcode = $db->record[recipient_zipcode]; $stored_recp_country_id = $db->record[recipient_country_id]; $stored_recp_tel = $db->record[recipient_telephone]; $stored_recp_fax = $db->record[recipient_fax]; $stored_recp_email = $db->record[recipient_email]; #set order_id to cookie2 if($cookie2!="") { $new_order_id = $cookie2; } #obtain new order_id for brand new order if($cookie2=="") { $querystr = "SELECT MAX(order_id) AS max_order_id FROM aqua_user_order"; $db->query($querystr); $db->next_record(); $max_order_id = $db->record[max_order_id]; $new_order_id = $max_order_id + 1; } else { $new_order_id = $cookie2; } } } #obtain the country name base on the country_id $querystr = "SELECT * FROM aqua_country WHERE country_id = '$stored_recp_country_id'"; $db->query($querystr); if($db->num_rows()>0) { $db->next_record(); $stored_recp_country = $db->record[country_name]; } $pg_title = orderpg1; INCLUDE "header.php"; ?> \n"; print "\n"; print "\n"; print "

 

\n"; print "
\n"; print "
\n"; print "
\n"; print "
SHIPMENT DETAIL
\n"; print "
\n"; print "\n"; print "\n"; print "\n"; print "Country of Port\n"; print ":\n"; print "\n"; print "\n"; print " \n"; print " Date of Arrival\n"; print ":\n"; print "\n"; print "/\n"; print "\n"; print "/\n"; print "(dd/mm/yyyy)\n"; print "\n"; print "\n"; print "\n"; print "Port Name\n"; print ":\n"; print "\n"; $querystr = "SELECT * FROM aqua_country"; $db->query($querystr); $counter = 0; while ($db->next_record()) { $stored_country_id[$counter] = $db->record[country_id]; $stored_country_name[$counter] = $db->record[country_name]; $area_selection = ""; $area_selection_id = ""; $querystr1 = "SELECT * FROM aqua_port WHERE country_id = '$stored_country_id[$counter]'"; $db2->query($querystr1); if($db2->num_rows()>0) { while ($db2->next_record()) { $area_id = $db2->record[port_id]; $area_name = $db2->record[port_name]; if ($area_selection != "") { $area_selection = $area_selection . ","; $area_selection_id = $area_selection_id . ","; } $area_selection = $area_selection . $area_name; $area_selection_id = $area_selection_id . $area_id; } } if ($area_selection != "") { #print "\n"; #print "\n"; print "\n"; print "\n"; } } print "\n"; print " \n"; print " \n"; print " \n"; print "\n"; print "\n"; print "Recipient Name\n"; print ":\n"; print "\n"; print "\n"; print " \n"; print "Recipient Telephone\n"; print ":\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "Recipient Email\n"; print ":\n"; print "\n"; print "\n"; print " \n"; print "Recipient Fax\n"; print ":\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "Recipient Country\n"; print ":\n"; print "\n"; print "\n"; print " \n"; print " \n"; print " \n"; print "\n"; print "\n"; print "Recipient Address\n"; print "  \n"; print "\n"; print "\n"; print " \n"; print "State\n"; print ":\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "City\n"; print ":\n"; print "\n"; print "\n"; print " \n"; print "Zip Code\n"; print ":\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "
\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "
\n"; print "

 

\n"; print "

\n"; print "\n"; print "

\n"; print "
\n"; INCLUDE "footer.php"; ?>