query($querystr); if($db->num_rows()>0) { $db->next_record(); $stored_user_id = $db->record[user_id]; $stored_user_password = $db->record[user_password]; $stored_user_name = $db->record[user_name]; $stored_user_address = $db->record[user_address]; $stored_user_state = $db->record[user_state]; $stored_user_city = $db->record[user_city]; $stored_user_zipcode = $db->record[user_zipcode]; $stored_user_country_id = $db->record[user_country_id]; $stored_user_telephone = $db->record[user_telephone]; $stored_user_handphone = $db->record[user_handphone]; $stored_user_fax = $db->record[user_fax]; $stored_user_email = $db->record[user_email]; $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_telephone = $db->record[recipient_telephone]; $stored_recp_fax = $db->record[recipient_fax]; $stored_recp_email = $db->record[recipient_email]; $stored_user_company_id = $db->record[user_company_id]; ?>
\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]; $counter = $counter + 1; } for($i = 0; $i < $counter; $i++) { if ($stored_user_country_id == $stored_country_id[$i]) { print "$stored_country_name[$i]\n"; } } print "\n"; ?> \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]; $counter = $counter + 1; } for($i = 0; $i < $counter; $i++) { if ($stored_recp_country_id == $stored_country_id[$i]) { print "$stored_country_name[$i]\n"; } } print "\n"; ?> \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]; $counter = $counter + 1; } for($i = 0; $i < $counter; $i++) { if ($stored_ship_dest_id == $stored_country_id[$i]) { print "$stored_country_name[$i]\n"; } } print "\n"; ?> \n"; $querystr = "SELECT * FROM aqua_port"; $db->query($querystr); $counter = 0; while ($db->next_record()) { $stored_port_id[$counter] = $db->record[port_id]; $stored_port_name[$counter] = $db->record[port_name]; $counter = $counter + 1; } for($i = 0; $i < $counter; $i++) { if ($stored_ship_port_id == $stored_port_id[$i]) { print "$stored_port_name[$i]\n"; } } print "\n"; ?>
USER PROFILE
User ID
:
  User Password
:
User Company ID
:
       
Name
:
  Address
:
State
:
  City
:
Zip Code
:
  Country
:
Telephone
:
  Handphone
:
Fax
:
  Email
:
 
 
     
 
 
RECIPIENT PROFILE
Name
:
  Address
:
State
:
  City
:
Zip Code
:
  Country
:
Telephone
:
   
 
 
Fax
:
  Email
:
 
 
     
 
 
SHIPMENT DETAIL
Country of Port
:
  Port Name
: