/    Sign up×
Community /Pin to ProfileBookmark

Making one option selected in a drop down

hi all,

I have two drop down menus. First one is location. When you change location page refreshes and comes with the selected area. So with the refresh,the second drop down changes to the sub-locations of the selected location. For example:

if the default location is Fethiye. Sub-location drop down shows the sub-locations of Fethiye. When you change location to Bodrum. Page refreshes like location.asp?location=Bodrum and sub-locations of Bodrum appears in the sub-locations drop down.

My problem is when I refresh the page, the selected location must be selected in the dropdown. I don’t know how to make the selected location “selected” on the location drop down.

Any idea???

Thanks

Here is my code:

<?php
if ( ! isset($location) ) {
$location=”Bodrum”;
}
@mysql_connect ( “localhost”, “root”, “passwd” ) || die (“MySQL’e baglanamadim”);
mysql_select_db ( “ceyhun” ) || die (“Veritaban&#305;n&#305; seçemedim”);
$sorgu=mysql_query(“Select *from locations”);
$sorgu2=mysql_query(“Select *
from sublocations where Location=’$location'”);
?>
<html>

<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=windows-1254″>
<title>Location</title>
<script>
function changelst_a()
{
var location = document.getElementById(“location”);
if(location.value != “#”) document.location.href = location.value + “-property-search.htm?location=”;
}
</script>
</head>

<body topmargin=0 leftmargin=0>
<center><img border=”0″ src=”images/propertysearch.gif” width=”155″ height=”52″></center><div align=”center”>
<table border=”0″ width=”192″ cellspacing=”1″ cellpadding=”0″ id=”table5″>
<form method=”POST” action=”property-search.htm”>
<tr>
<td width=”190″>
<font style=”font-family: Verdana; font-size: 8pt” color=”#627CC9″>Location:</font></td>
</tr>
<tr>
<td width=”190″>
<select size=”1″ name=”location” id=”location” onchange=changelst_a() style=”font-family: Verdana; font-size: 8pt”>
<?php
while ($oku = mysql_fetch_array($sorgu)) {
echo “<option value=” . $oku[‘locationadi’] . “>” . $oku[‘locationadi’] . “</option>”;
}
?>
</select></td>
</tr>
<tr>
<td width=”190″>
<font style=”font-family: Verdana; font-size: 8pt” color=”#627CC9″>Sublocation:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></td>
</tr>
<tr>
<td>
<select size=”1″ name=”MevkiiNo” style=”font-family: Verdana; font-size: 8pt”>
<?php
while ($oku2 = mysql_fetch_array($sorgu2)) {
echo “<option value=” . $oku2[‘SubLocation’] . “>” . $oku2[‘SubLocation’] . “</option>”;
}
?> </select> </td>
</tr>
<tr>
<td width=”190″><font style=”font-family: Verdana; font-size: 8pt” color=”#627CC9″> Property Type:</font></td>
</tr>
<tr>
<td><select size=”1″ name=”PropertyType” style=”font-family: Verdana; font-size: 8pt”>
<option value=”1″ selected>All</option>
<option value=”2″>Villa</option>
<option value=”3″>Apart</option>
<option value=”4″>Inv.Project</option>
</select></td>
</tr>
<tr>
<td><font style=”font-family: Verdana; font-size: 8pt” color=”#627CC9″>Price:</font></td>
</tr>
<tr>
<td width=”190″>
<select size=”1″ name=”Price” style=”font-family: Verdana; font-size: 8pt”>
<option value=”1″ selected>All</option>
<option value=”2″>20.000 – 40.000</option>
<option value=”3″>40.000 – 60.000</option>
<option value=”4″>60.000 – 80.000</option>
<option value=”5″>80.000 – 100.000</option>
<option value=”6″>100.000 – 150.000</option>
<option value=”7″>150.000 &gt;</option>
</select></td>
</tr>
<tr>
<td width=”190″>
<font style=”font-family: Verdana; font-size: 8pt” color=”#627CC9″>Currency:</font></td>
</tr>
<tr>
<td height=”6″ width=”190″>
<select size=”1″ name=”cur” style=”font-family: Verdana; font-size: 8pt”>
<option value=”GBP” selected>GBP</option>
<option value=”EURO”>EURO</option>
<option value=”USD”>USD</option>
</select><font size=”1″>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</font></td>
</tr>
<tr>
<td height=”6″><input type=”submit” value=”Search” name=”B1″ style=”font-size: 8pt; font-family: Verdana; border-style: outset; border-width: 1px” onClick=”
form . action = ‘propertysearch.asp’
form . target = ‘_top’
form . submit (); “></td>
</tr>
</form>
</table>
</body>

</html>
<?php
mysql_close();
?>

to post a comment
PHP

3 Comments(s)

Copy linkTweet thisAlerts:
@bokehSep 17.2006 — [code=php]<?php
while ($oku = mysql_fetch_array($sorgu))
{
echo '<option value="' . $oku['locationadi'] . '"'.
(($oku['locationadi'] == @$_GET['location']) ? ' selected="selected"' : null ).
'>' . $oku['locationadi'] . '</option>';
}
?>[/code]
Copy linkTweet thisAlerts:
@telmessosauthorSep 17.2006 — For some reason it doesn't work. Could you tell me how I can assign the values coming from the address bar to a variable

E.G: if the address is git.php?adi=telmessos&soyadi=test

in git.php when i try to write $adi and $soyadi i get an error of undefined variable
Copy linkTweet thisAlerts:
@telmessosauthorSep 17.2006 — ok I sorted out. thanks for the help ?
×

Success!

Help @telmessos spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.19,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...