Validating between 2 drop down menus so only one can be selected php

Question

I have a script below which the user logs a php form.

There is a section with 2 drop down menus next to each other, 'npc_battery_n_code' and 'npc_battery_other_code'.

What I am trying to do is to make it so one of these drop down menus has to have an option selected for the form to be submitted, but not both or none.

So for example, if an option gets selected in 'npc_battery_n_code' and then the user selects another option in 'npc_battery_other_code', then the value of the 'npc_battery_n_code' will revert to the 'None' option.

Any suggestions welcome

     

     Heading

     You forgot to enter the Quantity';
     }  

     if (!empty($_POST['npc_customer_name'])) {
     $customer = escape_data($_POST ['npc_customer_name']);
     } else {
     $customer = FALSE;
     echo 'You forgot to enter the Customer Name';
     }  

     if (!empty($_POST['npc_registration_no'])) {
     $rego = escape_data($_POST ['npc_registration_no']);
     } else {
     $rego = FALSE;
     echo 'You forgot to enter the Customer Rego Number';
     }  

     if (!empty($_POST['npc_suo_no'])) {
     $suo = escape_data($_POST ['npc_suo_no']);
     } else {
     $suo = FALSE;
     echo 'You forgot to enter the SUO Number';
     }  

     if (!empty($_POST['npc_amb_club_no'])) {
     $repair_order = escape_data($_POST ['npc_amb_club_no']);
     } else {
     $repair_order = FALSE;
     echo 'You forgot to enter the A-Club number';
     }  

     if (!empty($_POST['npc_repair_order'])) {
     $amb_club = escape_data($_POST ['npc_repair_order']);
     } else {
     $amb_club = FALSE;
     echo 'You forgot to enter the Repair Order';
     }  

     if (!empty($_POST['npc_invoice_no'])) {
     $inv = escape_data($_POST ['npc_invoice_no']);
     } else {
     $inv = FALSE;
     echo 'You forgot to enter the Invoice Number ';
     }  

     if (!empty($_POST['npc_entry_userdate'])) {
     $inv_date = escape_data($_POST ['npc_entry_userdate']);
     } else {
     $inv_date = FALSE;
     echo 'You forgot to enter the Invoice Date';
     }

     if ($quantity && $customer && $rego && $suo && $repair_order && $amb_club && $inv && $inv_date)  {

     $uid = @mysql_insert_id(); //Get the url ID.
     $query = "INSERT INTO npc_sales_list 
     (npc_item_id , sp_user_id, npc_battery_n_code, npc_battery_other_code, npc_quantity, 
     npc_customer_name, npc_registration_no, npc_suo_no, npc_amb_club_no, npc_repair_order,
     npc_entry_userdate, npc_usertype, npc_points, npc_bonus_points, npc_entry_date)
     VALUES
     ('$uid', '$users', '$_POST[npc_battery_n_code]', '$_POST[npc_battery_other_code]', '$quantity',
     $customer , $rego, $suo, $amb_club , $repair_order, 
     $inv , 'NPC', '5' , '0' , NOW())";
     $result = mysql_query ($query) or trigger_error
     ("Query: $query

MySQL Error: " .mysql_error());

     if ($result = @mysql_query($query)) {

     //Finish the page.
     echo 'The sale with invoice number: ' . $inv . '       

     is now registered into the system.
     If you would like to log in further sales, please click here
     If you would like to view your sales log, please click here
     ';
     include ('./includes/footer.html'); // Include the HTML footer.
     exit();

     } else { // If it did not run OK.
     echo 'You could not be
     registered due to a system error. We apologize for any
     inconvenience.';
     }

     } 

     } else { // If one of the data tests failed.
     echo 'Please check all manatory fields are complete and try again.
     ';
     }

     mysql_close(); // Close the database connection.

     ?>                         


     


     

     
     NPC Vehicle*
     
     

     
     Other *
     
     
     

     
     Quantity *
     
     

     
     Customer name*
     
     

     
     Rego number *
     
     

     
     SUO No.*
     
     

     
     A-Club ID*
     
     

     
     Repair Order *
     
     

     
     Invoice No. *
     
     

     
     Invoice Date *
       
     

     
     
     

      
     
     
     

     Footer

Leon Kramer · Accepted Answer

jquery: select and unselect items of listbox is what you are looking for.

How you want your script to work cannot be achieved with PHP or Mysql. You can only work with the data when the website is loaded. If you want to edit the data without refreshing the page you need to use JavaScript, or more advanced jQuery.

Validating between 2 drop down menus so only one can be selected php

Answers (1)

Related Questions