<form action="sokning.php" method="POST">
<select id="Select1" name="Select1" title="Hela landet">
<option value="" selected>--Hela landet--</option>
<?php
require ("dbconnect.php");
$id = $_POST['Select1'];
$sql = "Select Lan from Butiksplats where Lan !='' group by Lan order by Lan";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$selected= ($row['Lan']==$id) ? "selected='selected'" : "";
echo("<option value=\"" . $row['Lan'] ."\" $selected>". $row['Lan'] . "</option>\n");
}
?>
</select>
<select id="Select2" name="Select2" title="Media-reklamtyp">
<option value="" selected>--Reklamtyp?--</option>
<?php
require ("dbconnect.php");
$id2 = $_POST['Select2'];
$sql = "Select Medium from Marknadsforingskalla where Medium !='' group by Medium order by Medium";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$selected= ($row['Medium']==$id2) ? "selected='selected'" : "";
echo("<option value=\"" . $row['Medium'] ."\" $selected>". $row['Medium'] . "</option>\n");
}
?>
Frågan#1
Hej!
Jag har ett litet problem. När jag trycker på sök i formuläret vill jag att det valda alternativet ska stanna i option value fältet. Nu uppdateras sidan och värdena i option value fälten töms vilket jag inte vill! Hoppas ni förstår vad jag menar...
Här är min kod:
<form action="sokning.php" method="POST">
<select id="Select1" name="Select1" title="Hela landet">
<option value="" selected>--Hela landet--</option>
<?php
require ("dbconnect.php");
$id = $_POST['Select1'];
$sql = "Select Lan from Butiksplats where Lan !='' group by Lan order by Lan";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
echo("<option value=\"" . $row['Lan'] ."\">". $row['Lan'] . "</option>\n");
}
?>
</select>
<select id="Select2" name="Select2" title="Media-reklamtyp">
<option value="" selected>--Reklamtyp?--</option>
<?php
require ("dbconnect.php");
$id = $_POST['Select2'];
$sql = "Select Medium from Marknadsforingskalla where Medium !='' group by Medium order by Medium";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
echo("<option value=\"" . $row['Medium'] ."\">". $row['Medium'] . "</option>\n");
}
?>
osv...
Hur ska jag gå tillväga? Visa gärna med kodexempel!
Tack för hjälpen!