if statement problem - easy question

[Anon]

Please forgive my ignorance in advance.

I have a form like this:

Location (name: location) w/ a drop down menu that includes "None" as one of the values.

Location if None: (name: other) is a text box to type in another location.

On my form_results.php page I'd like to use "other" if "location" is None.

I've used this and several other variations w/ no success:

if ($location == "None")
$other = $location;

It just keeps inserting "None" in the database. I know this is simplistic, what am I doing wrong? Thank you in advance for your help.

[Anon]

if i understand you, do this ...

if ($location == "None")
$location = "Other";

[[deleted]]

If I understand if correctly, you want to insert the value of $location, but not if $location contains "None".
If $location contains "None" then you want to insert the value of $other instead right?

if ($location == "None")
{
$location = $other;
}

$sQuery = "INSERT INTO table (field) VALUES ($location)";

---

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[Anon]

Yes - that is exactly what I wanted to do but it wasn't working.... I'm going to re-check my query & make sure everything else is ok.

Thanks a bunch