Dropdown list - Trying to get default populated from db.

[Oli]

Nooby question but when I try and get this to work (it should identify which
rows in the database have GK, MID, DEF, FWD against them and then put
SELECTED into the option value to give a default of what the entry is
currently) it just adds SELECTED to all the results as if $row["Position"]
is returning true against all four conditions? What am I doing wrong?

Thanks,

O.

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo("<td>" . $row["Surname"] . "</td>");
echo("<td>" . $row["TeamName"] . "</td>");
?>
<td><select name="select2">
<option value="GK"<? if ($row["Position"] = "GK") {?>SELECTED<?}
?>>GK</option>
<option value="DEF"<? if ($row["Position"] = "DEF") {?>SELECTED<?}
?>>DEF</option>
<option value="MID"<? if ($row["Position"] = "MID") {?>SELECTED<?}
?>>MID</option>
<option value="FWD"<? if ($row["Position"] = "FWD") {?>SELECTED<?}
?>>FWD</option>
?>>
</select></td>
<?

echo("<td>" . $row["Selected"] . "</td>");
}

[Pieter Nobes]

Oli wrote:

<td><select name="select2">
<option value="GK"<? if ($row["Position"] = "GK") {?>SELECTED<?}
?>>GK</option>
<option value="DEF"<? if ($row["Position"] = "DEF") {?>SELECTED<?}
?>>DEF</option>
<option value="MID"<? if ($row["Position"] = "MID") {?>SELECTED<?}
?>>MID</option>
<option value="FWD"<? if ($row["Position"] = "FWD") {?>SELECTED<?}
?>>FWD</option>
?>>
</select></td>
<?

echo("<td>" . $row["Selected"] . "</td>");
}

You have to use == instead of =. = means assignment, so you actually
assign GD, DEF, ... to $row['Position'], which returns true since it
worked. If you'd use if ( $row['Position'] == '...' ) your script should
work.

--
Pieter Nobels

[Oli]

You beauty!! :D

O.

"Pieter Nobes" <pi******@MOVE.opengate.be> wrote in message
news:1L***********************@phobos.telenet-ops.be...

You have to use == instead of =. = means assignment, so you actually
assign GD, DEF, ... to $row['Position'], which returns true since it
worked. If you'd use if ( $row['Position'] == '...' ) your script should
work.

--
Pieter Nobels

[Oli]

Next question I guess is how do I get this huge table to pass its variables
back to the database after a submit is um..submitted..

From what I have read, normally I would use the POST method and that would
pass the variables and then I could put them back in the database but as all
of these variables have the same names, how best to do it?

O.

"Oli" <ov**********@mail.com> wrote in message
news:cg**********@titan.btinternet.com...

You beauty!! :D

O.

[Tim Van Wassenhove]

In article <cg**********@hercules.btinternet.com>, Oli wrote:

Next question I guess is how do I get this huge table to pass its variables
back to the database after a submit is um..submitted..

From what I have read, normally I would use the POST method and that would
pass the variables and then I could put them back in the database but as all
of these variables have the same names, how best to do it?

<?php
if (isset($_POST['submit']))
{
echo "SELECTED VALUES: ";
while (list ($key, $val) = each ($_POST['multiselect']))
{
echo "$val ";
}
echo "<br>\n";
}
?>

<form method="post">
<select name="multiselect[]" multiple>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
<input type="submit" value="submit" name="submit" />
</form>

--
Tim Van Wassenhove <http://home.mysth.be/~timvw>

[Tony Marston]

"Oli" <ov**********@mail.com> wrote in message
news:cg**********@hercules.btinternet.com...

Next question I guess is how do I get this huge table to pass its
variables
back to the database after a submit is um..submitted..

From what I have read, normally I would use the POST method and that would
pass the variables and then I could put them back in the database but as
all
of these variables have the same names, how best to do it?

If you construct your HTML document using data from multiple database rows
then you will have duplicate field names. The way around this is to index
each fieldname by row number, as in field[$row].

When the form is posted back PHP will present you the data in the format:

fieldname: array =
0: string = value
1: string = value
2: string = value

You simply step through this like any other array. Easy when you know how.

HTH.

--
Tony Marston

http://www.tonymarston.net