selecting drop-down values from a db

[oolongdavies]

I have a script that gets values from a db and populates a dropdown box.

 

I would like to autoselect the value from the db that matches $currentvalueoffruit?

 

Does anyone know how to achieve this?

Here's the code...

 

$currentvalueoffruit = $_SESSION['fruit'];

$sql = "SELECT * FROM tbl_food";
	 $result = mysql_query($sql);
	 while ($row = mysql_fetch_assoc($result)) {
	 			 echo '<option value="' . $row['fld_fruit'] . '"';
				 echo '>';
	 			 echo $row['fld_fruit] .  '</option>';
	}

 

 

[vbnullchar]

do it like this

<?php
$currentvalueoffruit = $_SESSION['fruit'];

$sql = "SELECT * FROM tbl_food";
	 $result = mysql_query($sql);
	 while ($row = mysql_fetch_assoc($result)) {
		echo "<option ".($row['fld_fruit']==$currentvalueoffruit?' selected ':' ')." value=$row[fld_fruit]>$row[fld_fruit]</option>";
	}

?>

[oolongdavies]

Thanks for that, but I'm getting the following error - parse error, unexpected T_CONSTANT_ENCAPSED_STRING

 

it relates to line 34 which is this line:

 

echo "<option ".($row['fld_fruit']==$currentvalueoffruit?' selected ':' ')." value=$row[fld_fruit]>$row[fld_fruit]</option>";

 

Any ideas?

TIA

[vbnullchar]

Thanks for that, but I'm getting the following error - parse error, unexpected T_CONSTANT_ENCAPSED_STRING

 

it relates to line 34 which is this line:

 

echo "<option ".($row['fld_fruit']==$currentvalueoffruit?" selected ":" ")." value=$row[fld_fruit]>$row[fld_fruit]</option>";

 

Any ideas?

TIA

 

how 'bout this

 

echo "<option ".($row['fld_fruit']==$currentvalueoffruit?" selected ":" ")." value=$row[fld_fruit]>$row[fld_fruit]</option>";