edit a form with 10 drop downs

[ale1981]

Hi,

I have a form which has 10 dropdown lists on it, $hometeam1 - $hometeam10.
Thanks to a couple of guys on here I have been able to insert the info into the db fine, but my problem now is passing the info from the db to the dropdown lists when the record is edited, so that each dropdown shows the teamname that corresponds with the ID from the database, 😕 ?!

Here is the code I have been experimenting with;

	
	global $db;
	showheader();
	$id = $_GET['id'];
	$result = $db->sql_query("SELECT * FROM 4casts WHERE id='$id'",false,__FILE__,__LINE__);
	$row = $db->sql_fetchrow($result);
	$deadline = date('d-m-y', $row['deadline']);

// Build the drop down menus and store the generated code in an array
$teamlist = $db->sql_query("SELECT id,name FROM teams ORDER BY name");
$ddhome = array();
while (list($team_id, $team_name) = $db->sql_fetchrow($teamlist)) {
	for ($i = 1; $i <=10; $i++) {
		$home = $row['hometeam'.$i];
		if(isset($home) && !empty($home))
		{
			$sel = ($home == $team_id) ? 'selected' : '';
		} else {
			$sel = ($home == $team_name) ? 'selected' : '';
		}
	}
	$ddhome[] = '<option ' . $sel . ' value="' . $team_id . '">' . $team_name . '</option>';
}
//

... but because of my limited knowledge, cant seem to get it to work!

Thanks in advance for any help.

[Weedpacket]

Leaving aside the problem of what will happen when you get an eleventh team....

This bit

if(isset($home) && !empty($home))
            {
                $sel = ($home == $team_id) ? 'selected' : '';
            } else {
                $sel = ($home == $team_name) ? 'selected' : '';
            } 

seems curious. If $home is !empty, then it isset, so it's not necessary to make both tests, just that second one. But that's not the problem. The problem is that it says if $home isn't set or it is empty, then $sel depends on whether or not $home==$team_name. And it never will. (Besides $home will always be set - it's set to $row['hometeam'.$i].)

In the absence of a description of the symptoms (do you output or return $ddhome later in the function?) it's only a guess that that has anything to do with the problem.

[ale1981]

Hey weedpacket,

There will always be 10 teams, or I wouldnt of coded it like that 😛

Sorry, the symptoms are that only the first team from the db (hometeam1) is selected and is then displayed in all ten dropdown lists.

Yes, $ddhome is output in a seperate file which I call;

	<table width="60%"  border="0" cellspacing="5" cellpadding="0">

  	<tr>

    	<td><strong>Game</strong></td>

    	<td><strong>Kick Off</strong></td>

    	<td><div align="right"><strong>Home Team </strong></div></td>

    	<td width="100"><div align="center">&nbsp;</div></td>

    	<td><strong>Away Team </strong></td>

  	</tr>';

for ($i = 1; $i <= 10; $i++) {

	echo '<tr>

	<td>'.$i.'</td>';

	$kickoff = $row['kickoff'.$i];

	echo '<td><input type="text" name="kickoff'.$i.'" value="'.$kickoff.'" size="10" maxlength="5">&nbsp; (hh:mm)</td>

	<td><div align="right">';

	echo '<select name="hometeam'.$i.'"><option value="0">Please Select...</option>\n';

	echo implode("\n",$ddhome) . "\n";

	echo '</select></div></td>

    		<td width="100"><div align="center">v</div></td>

    		<td>';

    		echo '<select name="awayteam'.$i.'"><option value="0">Please Select...</option>\n';

    		echo implode("\n",$ddaway) . "\n";

    		echo '</select></td>

    		</tr>';

}

echo '</table>

... like this

require('edit_file.php');

[ale1981]

headache!!

[ale1981]

Anybody know what I am doing wrong? Still cant get this to work 🙁