limit-registration

prepare("SELECT count(option_a) FROM `registration` WHERE option_a = :option_a"); $data1 = array( ':option_a' => "Option A" ); $query1->execute($data1); $number_of_option_a = $query1->fetchColumn(); $number_of_option_a_left = 12 - $number_of_option_a; $query2 = $pdo->prepare("SELECT count(option_a) FROM `registration` WHERE option_b = :option_b"); $data2 = array( ':option_b' => "Option B" ); $query2->execute($data2); $number_of_option_b = $query2->fetchColumn(); $number_of_option_b_left = 40 - $number_of_option_b; $query3 = $pdo->prepare("SELECT count(option_c) FROM `registration` WHERE option_c = :option_c"); $data3 = array( ':option_c' => "Option C" ); $query3->execute($data3); $number_of_option_c = $query3->fetchColumn(); $number_of_option_c_left = 4 - $number_of_option_c; ?> limit-registration