how to output data in a drop down list

TGixer

i have a form in which i pull data into. it works fine...my question is

I have a field in the form that is a drop down menu:
lets says
State: NY, NJ, MA
are the 3 dropdown option

Im pulling the user data from the database, so lets say John Doe, his record is MA.

how to i code the form to output that State should have MA the selected option??

the text boxes are easy:

<input name=\"weight\" type=\"text\" id=\"weight\" 
	  value=\" ".
$row_user['weight'] ."\" size=\"5\" class=\"form_buttons\">

but how do i do the drop downs?

<select name=\"state\" id=\"state\" class=\"form_buttons\">
      <option  value=\"NY\">NY</option>
      <option value=\"\NJ">NJ</option>
      <option value=\"MA\">MA</option>
    </select>

i want it to say:

Hope i made sense.

TIA

stolzyboy

try something along these lines

<?
while ($row = mysql_fetch_array($result))
{
?>
<option value="<? echo $row[field]; ?>" <? if ($row[field] == "$variablefromform"){ echo "selected"; }else{} ?>><? echo $row[field]; ?></option>
<?
}
?>

TGixer

Thanks,

ill play with it from there!

TGixer

Not having much luck!

:mad:

<select name=\"eye\" id=\"eye\" class=\"form_buttons\">
      <option" .
if ($row_user['eye'] =="Blue") { echo "selected";} else {}
	  . "value=\"Blue\">Blue</option>
      <option value=\"Brown\">Brown</option>
      <option value=\"Green\">Green</option>
    </select>

whats wrong with this, parse error.

stolzyboy

<?
other php
?>
<select name="eye" id="eye" class="form_buttons">
<option value="Blue" <? if ($row_user['eye'] == "Blue"){ echo "selected";} else {} ?>>Blue</option>
<option value="Brown" <? if ($row_user['eye'] == "Brown"){ echo "selected";} else {} ?>>Brown</option>
<option value="Green" <? if ($row_user['eye'] == "Green"){ echo "selected";} else {} ?>>Green</option>
</select>
<?
more php stuff
?>

TGixer

The one problem i cant end the php

$form block = "

<select name=\"eye\" id=\"eye\" class=\"form_buttons\">
<option" .
if ($row_user['eye'] =="Blue") { echo "selected";} else {}
. "value=\"Blue\">Blue</option>
<option value=\"Brown\">Brown</option>
<option value=\"Green\">Green</option>
</select>
";

i cant use <? ?>

TGixer

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING'

on the line that i changed with your code😕

stolzyboy

what is the reason you cant hop in and out of php, just because you have it equal to $form_block;

TGixer

yes

i have a huge form. all inside the var $form_block

stolzyboy

ok, what is the reason you have the whole form inside the block, i am just curious, can you attach your whole code

TGixer

my code is too long to post, it wont allow.

regardless

it cant end the php ?> to get it to work

is there some way to use Dot notation

"text" . if () {echo "selected"} ; . "more text"

stolzyboy

i have tried it numerous ways, and i didn't say post your code i said attach it as a file

TGixer

sorry, i misunderstood

However, i got it working!!

<select name=\"eye\" id=\"eye\" class=\"form_buttons\">
	  <option>Eye</option>
      <option "; 
	  if ($row_user['eye'] == "Blue")
	  {
	 	  $form_block .= "selected";
	  }
	  $form_block .= " value=\"Blue\" >Blue</option> 
      <option "; 
	  if ($row_user['eye'] == 'Brown')
	  {
	  $form_block.= "selected";
	  }
	 	  $form_block .= " value=\"Brown\">Brown</option>
      <option";
	   if ($row_user['eye'] == "Green")
	  {
	 	  $form_block .= "selected";
	  }
	  $form_block .=" value=\"Green\">Green</option>
    </select>