Auto select
Hejsa,Jeg har denne form, der bruges til redegering af en vare.
Producenten vælges med en dropdown menu. Jeg vil gerne have at det nuværende brand (producent) bliver markeret (selected) med det samme.
Dette er min form:
<form action="reels_edit_ok.php?id=<? echo $row[id];?>" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="leftrightspan">
<tr>
<td bgcolor="#80BFFF" cbgcolor="#B3D9FF"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">Edit
product: <? echo $row[brand];?>, <? echo $row[model];?></font></strong></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="leftrightspan">
<tr>
<td width="155">Brand:</td>
<td width="1136" colspan="2"><select name="brand">
<?
$query = mysql_query("SELECT * FROM brand ORDER BY brand");
while($row = mysql_fetch_array($query))
{
?>
<option value="<? echo $row[brand];?>"><? echo $row[brand];?></option>
<?
}
?>
</select></td>
<?
$query = mysql_query("SELECT * FROM reels WHERE id='$id' ");
while($row = mysql_fetch_array($query)) {
?>
</tr>
<tr>
<td width="155">Model:</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[model]?>"></td>
</tr>
<tr>
<td width="155">Modelcode/number::</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[model_nr]?>"></td>
</tr>
<tr>
<td width="155">Model link:</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[model_link]?>"></td>
</tr>
<tr>
<td width="155">Category:</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[cat]?>"></td>
</tr>
<tr>
<td width="155">Gear:</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[gear]?>"></td>
</tr>
<tr>
<td width="155">Bearings:</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[bearings]?>"></td>
</tr>
<tr>
<td width="155">Weight:</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[weight]?>"></td>
</tr>
<tr>
<td width="155"><p>Line cap.:</p>
</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[line]?>"></td>
</tr>
<tr>
<td width="155">Warranty:</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[warranty]?>"></td>
</tr>
<tr>
<td width="155">Added by:</td>
<td colspan="2"> <input type="text" name="brand_link" value="<? echo $row[added_by]?>"></td>
</tr>
<tr>
<td width="155">Status:</td>
<td colspan="2">
<select name="activated">
<option value="1" <? if ($row['activated']==1) { echo "selected='selected'" ;} ?> >Active</option>
<option value="0" <? if ($row['activated']==0) { echo "selected='selected'" ;} ?> >Inactive</option>
</select>
</td>
</tr>
<tr>
<td> </td>
<td colspan="2"><input name="submit" type="submit" value="Submit">
<input name="reset" type="reset" value="Reset">
| <a href="reels_delete.php?id=<? echo $row[id];?>"><font color="#000000">Delete
Brand</font></a></td>
</tr>
</table>
</form>
<?
}
?>
