Selecting Drop Down Value From DB to Edi

[sfmnetsys]

I have the below code that populates a drop down list. The code will correctly insert the value $StateID into another a table. The problem I am running into is that when I select the record to edit the drop-downlist has the first option as the value instead of what the corresponding StateID in the column reads. How can I correct this? The form to insert and edit have the below code and correctly insert the StateID. I tried to write and if statement to state that if the StateID were == to the StateID in he table then print selected, but I think I am missing something.

Any suggestions?

Thanks.

<?php

// populates state drop-down list

$get_stateid_query = mysql_query("SELECT * FROM State INNER JOIN RaceResults ON State.StateID WHERE RaceID='$RaceID'");

echo " <select name=\"StateID\">\n";

while ($myrow = mysql_fetch_array($get_stateid_query)) {

echo ' <option value="'.$myrow["StateID"].'">'.$myrow["StateName"]."</option>\n";
}
echo " </select>\n";
?>

[tomhath]

You were probably close. The word SELECTED should appear inside the option tag (between the <> brackets). Generate the page, view the source and see what you have.

[sfmnetsys]

My IF statement doesn't work, but I think that is mainly because of syntax. The other problem is that for this (the below) and other drop-down lists using this query all of the values = 1. I understand why this is. I have $StateID = what the StateID is in the Inner Join. How do I fix this?

<?php

// populates state drop-down list

$get_stateid_query = mysql_query("SELECT * FROM State INNER JOIN RaceResults ON State.StateID WHERE RaceID='$RaceID'");

echo " <select name=\"StateID\">\n";

while ($myrow = mysql_fetch_array($get_stateid_query)) {

echo ' <option value="'.$myrow["StateID"].'" if ($StateID == $StateID) print "selected">'.$myrow["StateName"]."</option>\n";
}
echo " </select>\n";
?>