[Resolved] php syntax - showing a field based on value

[hongnfox]

Hi,

I have a form where I want to display a field as either static data or a pull-down list, depending on the data. I'm not sure what the right syntax is for writing php with html (it's giving me a parsing error)...For example, I want to display a field as an echo of data from the db if there's actually data in it. If that field is empty, I want for the user to be able to choose data from a pull-down list. What makes it more complicated is that it's in the <td> tag...not sure how to incorporate php with this tag. Here's the code...

<td>
<?php if (is_null($escrow_id))
echo "is null";
<select name="escrow_id">
<option value="<?php echo $escrow_id?>" selected <?php echo $escrow_id?>></option>
<?php
//create pull-down list
$sql6 = "SELECT escrow_id
FROM escrow
ORDER BY escrow_id
";
$result = mysql_query($sql6)
or die("sql6 error: " . mysql_error());
$row = mysql_fetch_array( $result , MYSQL_ASSOC );
while ($row = mysql_fetch_array($result) ){
if ( $row['escrow_id'] == $escrow_id){
$selected = " SELECTED";
} else {
$selected = "";
}
echo '<OPTION value="'.$row['escrow_id'].'"'.$selected.'>'.$row['escrow_id'].'</OPTION>'."\r\n";
}
?>
</select>
else
echo "is not null";
<?php echo $escrow_id?>&nbsp;
?>
</td>

What should I change? Thank you.

[dnast]

<td>
<?php if (is_null($escrow_id)) {
  echo "is null"; ?>
  <select name="escrow_id">
    <?php
	//create pull-down list
	$sql6 = "SELECT escrow_id
			 FROM escrow
		     ORDER BY escrow_id";
	$result = mysql_query($sql6)
            or die("sql6 error: " . mysql_error());
    $row = mysql_fetch_array( $result , MYSQL_ASSOC );
	while ($row = mysql_fetch_array($result) ){

     if ( $row['escrow_id'] == $escrow_id){
	    $selected = " SELECTED";
	 } else {
		$selected = "";
	 }
     echo '<OPTION value="'.$row['escrow_id'].'"'.$selected.'>'.$row['escrow_id'].'</OPTION>'."\r\n";
}
?>
  </select>
<?
  } else {
      echo "is not null";
      echo $escrow_id."&nbsp";
  }
?>
</td>

Untested, but looks right to me. I didn't change much. You pretty much had everything correct except some syntax problems and the extra <option> before your while loop.

Edit: Also, you should put your code inside

 tags when posting here. It makes it a lot easier to read and figure out what's wrong ;)

[hongnfox]

Thanks so much! Worked perfectly. ;-)