Dropdowns won't go into DB!

kilbey1

These dropdowns will not go into my DB!

//VALIDATE DRopdowns

	if($_POST['brainbond'] != "") {		
		if ($_POST['brainbond'] != strval(intval($_POST['brainbond']))) {
 		//if($_POST['brainbond'] != "1" && $_POST['brainbond'] != "2" && $_POST['brainbond'] != "3" && $_POST['brainbond'] != "4") {
			$error[] = 'Please enter a valid number for brainbond.com.';
		} else {
			$brainbond = $_POST['brainbond'];
		}
	}
	if(!empty($_POST['jobs24by7'])) {		
		if ($_POST['jobs24by7'] != strval(intval($_POST['jobs24by7']))) {
 			$error[] = 'Please enter a valid number for jobs24by7.com.';
		} else {
			$jobs24by7 = $_POST['jobs24by7'];
		}
	}
	if(!empty($_POST['job24x7'])) {		
		if ($_POST['job24x7'] != strval(intval($_POST['job24x7']))) {
 			$error[] = 'Please enter a valid number for job24x7.com.';
		} else {
			$job24x7 = $_POST['job24x7'];
		}
	}
	if(!empty($_POST['wowwe'])) {		
		if ($_POST['wowwe'] != strval(intval($_POST['wowwe']))) {
 			$error[] = 'Please enter a valid number for wow-we.com.';
		} else {
			$wowwe = $_POST['wowwe'];
		}
	}


//if validated, perform insert

$query = "INSERT INTO questionnaire (jobtype, search, searchmethod, experience, experiencewhy, jobboard, advertise, addlfeatures, brainbond, job24x7, jobs24by7, wowwe, contact, name, address, city, state, country, zip, date_entered) values ('$jobtype', '$search', '$searchmethod', '$experience', '$experiencewhy', '$jobboard_implode', '$advertise_implode', '$addlfeatures', '$brainbond', '$job24x7', '$jobs24by7', '$wowwe', '$contact', '$name', '$address', '$city', '$poststate', '$countries', '$zip', now())";

kilbey1

And it always seems to come back as empty (upon test). Why? And how can I fix this?

Here's an example of one of the dropdowns. Could this be the problem?

<select name="brainbond">
  <option value="1" selected>1</option>
  <option value="2">2</option>
  <option value="3">3</option>
  <option value="4">4</option>
</select>

Qaladien

one thing i always do when i am debugging is to add a few ECHO or PRINT statement of my variables as i go along ... trace your variables to make sure they are getting initialized with what you think they are ... also try adding a print of your final query on your page referred to so you can see exactly what is getting passed ... GLuck

Qaladien

kilbey1

Yep, I did. It's always coming up as empty, but it should never be empty - I don't allow for it in the dropdown.

This is even after commenting out all validation to see if something may be preventing from reaching the dropdown values.

Surely this is just a simple thing? People use dropdowns on their forms all the time. 🙂 I've searched all over, and as far as I can see, it looks good to me...