Page 1 of 2

drop down menu

Posted: Mon Jun 21, 2004 12:02 pm
by ddragas
Hi
I've got database with users profile.

If user want's to edit his profile, how can I display his data in drop down menu?

example:
if in database value is Yes
display in drop down menu selected Yes


I know conection to database, and retrive data from database.

All I need is sintaxe for displaying data in drop down menu .

Posted: Mon Jun 21, 2004 12:12 pm
by Illusionist

Code: Select all

<select name="ddbox">
<option>Yes
<option>No
<option>Maybe
</select>

Posted: Thu Jun 24, 2004 11:33 am
by ddragas
don't understand
what is "ddbox"?

Here is my code

Code: Select all

<?php
echo "<td width="30%"align="Left">" .  "<font color="#666666" size="2" face="Geneva, Arial, Helvetica, sans-serif">" . "bla_bla: " . "<td>" . "<select name="bla_bla" id="select3"><option value="$bla_bla">";// . "<br>";
                    echo "<option> </option>";
                    echo "<option value="Yes">yes</option>";
                    echo "<option value="No">no</option>";
                    echo "</select>";
echo "</td></tr>"; 



?>

Posted: Thu Jun 24, 2004 12:20 pm
by Illusionist
ok... So...

Posted: Thu Jun 24, 2004 1:09 pm
by ddragas
how to display in drop down menu selected Yes if value $bla_bla is "Yes"
or
how to display in drop down menu selected No if value $bla_bla is "No"

Posted: Thu Jun 24, 2004 1:12 pm
by dethron

Code: Select all

<select>
<option <? if($bla_bla == Yes) echo "selected" ?>>Yes 
<option<? if($bla_bla == No) echo "selected" ?>>No 
</select>

Posted: Thu Jun 24, 2004 1:57 pm
by ddragas
Thank you but
It's not working

Posted: Thu Jun 24, 2004 2:13 pm
by dethron
You must know the value of $bla_bla, so you must use an "echo" statement to see the value that is coming from db.

send me the HTML output of following lines, then let's see the condition.

Code: Select all

<?php
	echo "[".$bla_bla."]<br>";
	
	
	echo "<select>";
	if($bla_bla == "yes"){
		echo "<option selected value="yes">YES</option>";
		echo "<option value="no">NO</option>";
	}
	else{
		echo "<option value="yes">YES</option>";
		echo "<option selected value="no">NO</option>";
	}
	echo "</select>";
?>

Posted: Thu Jun 24, 2004 2:22 pm
by ddragas
I've got it to work.

Than you very much

Posted: Thu Jun 24, 2004 2:25 pm
by dethron
Please add a [SOLVED] tag to your topic,
so the valuable time of programmers won't be wasted :)
Thnx.

Posted: Thu Jun 24, 2004 2:28 pm
by ddragas
And what if I have 20 option values?

Posted: Thu Jun 24, 2004 2:30 pm
by dethron
use a for loop to display, and put a proper if-clause to add "selected" tag :)

Posted: Thu Jun 24, 2004 2:34 pm
by ddragas
Not shure that i Know how to do it. Can you help me.
Here are values that should be displayed in drop down menu

Code: Select all

<?php
                          echo "<option value="Istarska" selected>Istarska</option>";
                          echo "<option value="Primorsko-goranska">Primorsko-goranska</option>";
                          echo "<option value="Karlovaèka">Karlovaèka</option>";
                          echo "<option value="Lièko-senjska">Lièko-senjska</option>";
                          echo "<option value="Zadarska">Zadarska</option>";
                          echo "<option value="Šibensko-kninska">Šibensko-kninska</option>";
                          echo "<option value="Spitsko-dalmatinska">Spitsko-dalmatinska</option>";
                          echo "<option value="Dubrovaèko-neretvanska">Dubrovaèko-neretvanska</option>";
                          echo "<option value="Zagrebaèka">Zagrebaèka</option>";
                          echo "<option value="Sisaèko-moslavaèka">Sisaèko-moslavaèka</option>";
                          echo "<option value="Brdsko-posavska">Brdsko-posavska</option>";
                          echo "<option value="Vukovarsko-srijemska">Vukovarsko-srijemska</option>";
                          echo "<option value="Požeško-slavonska">Požeško-slavonska</option>";
                          echo "<option value="Osjeèko-baranjska">Osjeèko-baranjska</option>";
                          echo "<option value="Bjelovarsko-bilogorska">Bjelovarsko-bilogorska</option>";
                          echo "<option value="Virovitièko-podravska">Virovitièko-podravska</option>";
                          echo "<option value="Krapinsko-zagorska">Krapinsko-zagorska</option>";
                          echo "<option value="Koprivnièko-križevaèka">Koprivnièko-križevaèka</option>";
                          echo "<option value="Varaždinska">Varaždinska</option>";
                          echo "<option value="Meðimurska">Meðimurska</option>";
?>

Posted: Thu Jun 24, 2004 2:36 pm
by dethron
where the values come form?

If you have them in a db, then yes i can help.
Otherwise, you should write them as you did above.

Posted: Thu Jun 24, 2004 2:43 pm
by ddragas
Now I'll explain whole sitation.

What I'm doing is user edit-profile page. Those values are posible to be in database, depending what user has selected before (when he was making his profile).

Hope you've understood my situation and problem. If something is not clear enough please let me know.

Thank you