if(empty)statements/session variables

[Jim_Madrid]

If anyone can help me with this I would be incredibly grateful...have spent days trying to figure this out. Here are the basics

server model: PHP (although if you know it in other server model that okay too...can translate)
database: mysql

1. I have a 2 page form. When the user fills out the info on page form he is directed to the 2nd page of the form. A session variable has been created in the 2nd form to hold all the data from the 1st page. When the 2nd page is submitted all the data (stored from page 1 and new from page 2) are sent to the database.

2. Here is the problem. On page 1, I have several form fields (like combo boxes) that need to work together. For example: I have a text field (name=phylum) in which investigators add new phylum names which are eventually sent to database field "phylum" of the same name. Next to that is a select box (name=newphylum) that has all the names that the investigors have previously entered and that are dynamically retrieved from the database field "phylum".

So when a researcher fills out page 1 of the form he/she can either add a new name or select an already existing name from the select box. But just one of these values can be sent to the database, not both.

QUESTION 1:

How can I say and where would I put something that basically says the following:

if the phylum text field is left EMPTY (i.e. they don´t add a new name) and they select instead from the select box, that it is the value from the select box and not the text box that gets sent to the database.

QUESTION 2:

How do I pass the statement from question 1 into the session variable on page 2 of my form?

I´m at my wits end with this....Please help if you can

Thanks

Jim
Madrid, Spain

[nnichols]

all you need is a simple conditional statement -

$_SESSION['phylum'] = ($_POST['phylum_text'] ? $_POST['phylum_text'] : $_POST['phylum_select']);

Hope this helps 😉

[jarow]

Thank you so much!!! It works perfectly. I really can't thank you enough.

I have another question related to this that you may know the answer to as well.

If my form was not 2 pages, only 1 making it unneccessary to have a session variable, what kind of statement would I write to say basically the same thing...if "phylum" is empty use values from "newphylum" to insert into database field "phylum"

Again, many thanks

Jim
Madrid, Spain