PDA

View Full Version : Drop down menu problem

telmessos
09-17-2006, 11:52 AM
Hi all,

I use the following code to list the locations and sub-locations in the database. For some reason PHP does not give an error message. But do not list the locations and sub-locations in the dropdown menus. Any idea about that???

Thanks



<?php
if ( ! isset($location) ) {
$location="Bodrum";
}
@mysql_connect ( "localhost", "root", "passwd" ) || die ("MySQL'e baglanamadim");
mysql_select_db ( "ceyhun" ) || die ("Veritabanını seçemedim");
$sorgu="Select *from locations";
$sorgu2="Select *from sublocations where LocID='$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 = "property-search.htm?location=" + location.value;
}
</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)) {
if ( $oku[locationadi] = $location) {
echo "<option selected value=" . $oku['locationadi'] . ">" . $oku['locationadi']. "</option>";
}
else {
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();
?>
Mwnciau
09-17-2006, 12:38 PM
Original (easier to read):
<?php
if ( ! isset($location) ) {
$location="Bodrum";
}
@mysql_connect ( "localhost", "root", "passwd" ) || die ("MySQL'e baglanamadim");
mysql_select_db ( "ceyhun" ) || die ("Veritabanını seçemedim");
$sorgu="Select *from locations";
$sorgu2="Select *from sublocations where LocID='$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 = "property-search.htm?location=" + location.value;
}
</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)) {
if ( $oku[locationadi] = $location) {
echo "<option selected value=" . $oku['locationadi'] . ">" . $oku['locationadi']. "</option>";
}
else {
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();
?>


<?php
if (!isset($_POST['location']) ) { // ??
$location="Bodrum";
}
else {
$location = $_POST['location'];
}
mysql_connect ( "localhost", "root", "passwd" ) || die (mysql_error());
mysql_select_db ( "ceyhun" ) || die (mysql_error());
$sorgu="Select *from locations";
$sorgu2="Select *from sublocations where LocID='$location'";
?>
Taylor_1978
09-17-2006, 12:45 PM
I have only just woken up so only half with it so I apologise if my answer is wrong.. but I think your problem is that you are not actually setting a query.

Try this instead:

$sorgu=mysql_query("Select *from locations");
$sorgu2=mysql_query("Select *from sublocations where LocID='$location'");
Mwnciau
09-17-2006, 01:02 PM
Yeh that the prob... couldn't edit my post...