A diffrent selected value of a select form depending on a var

[son.of.the.morning]

I need my select dropdown to show the relevant option. I am using a GET action to pass the id of an article to another page (edit article page) with this i am selecting that specific record and passing it's data into form object in order to be modified and updated. The only issue is my category list is a dropdown and i need it to display the relivent category for that specific record.

 

hope that makes sence

[litebearer]

please post the relevant code that you have thus far

[son.of.the.morning]

<?php 

if(isset($_GET['id'])) {
	$id = $_GET['id'];	
	$a = "SELECT * FROM blog_posts WHERE id = $id";
	$query  = mysql_query($a) or die (mysql_error());
	$return = mysql_fetch_array($query);
}
else {
}
?>

 

<select name="color" class="SelectColor">
        <option id="red" value="red">red</option>
        <option id="blue" value="blue">blue</option>
        <option id="green" value="green">green</option>
        <option id="grey" value="grey">grey</option>
</select>

[litebearer]

Untested, unproof-read; however...

 

<?PHP
$colors = array("red","blue","green","grey");
$color_count = count($colors);
$what_color = "blue"; /* use the color from wherever to set this variable */
?>

<select name="color" class="SelectColor">
<?PHP
for($i=0;$i<$color_count;$i++) {
	?>
	<option id="<?PHP echo $colors[$i]; ?>" value="<?PHP echo $colors[$i]; 
		if($what_color == $colors[$i]) {
			echo "SELECTED"; 
		}
		?>">
		<?PHP echo $colors[$i]; ?>
	</option>
<?PHP
}
?>
</select>

[son.of.the.morning]

Thats for the help. I created a really simple solution.