[SOLVED] Get database value into option selected

[AdRock]

I have a form I use for editing a record and in there I have a select list.

 

I want the select list to be filled with 3 values I want the value in the database to be the selected option in the select list but it's not working properly

 

Any help?

 

This is a cut down version of the page with the important parts of the code

$db = & new MySQL($host,$dbUser,$dbPass,$dbName);
$get_id = check_input($_GET['id']);

$sql = "SELECT id, image, alternate, cat FROM image WHERE id=$get_id LIMIT 1";

$result = $db->query($sql);

while ($row = $result->fetch()) {
	$id = $row['id'];
	$image = $row['image'];
	$alternate = $row['alternate'];
	$category = $row['cat'];
}

$cats = array("Jack", "Honeylands", "Events");

 

and the form

<p><label class="imagelabel" for="category">Category: </label>
		<select name="gallery" size="1">
			<?php foreach($cats as $cat) {
				if($cat == $row['cat']) {
					echo '<option selected value="'.ucwords($category).'">'.ucwords($category).'</option>';
				}
				else {
					echo '<option value="'.ucwords($cat).'">'.ucwords($cat).'</option>';
				}
			}
			?>
		</select></p>

I have got it adding options for each of the array items but not selecting the one in the database

[AndyB]

Hvae you checked the generated HTML (view source) to see if your logic is working?

 

The correct syntax for option selected is:

 

<option value='something' selected='selected'> .... etc

[AdRock]

I checked that and it makes no difference.

 

Could it be becuase of this

if($cat == $row['cat']) {

[AndyB]

Have you checked the generated HTML (view source) to see if your logic is working?

[.josh]

I'm leaning toward what Andy is saying, as well.  But, failing that...

 

== is case sensitive.  Perhaps you have for instance jack instead of Jack in your db?