Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   3 dependable combo box problem (http://www.go4expert.com/forums/3-dependable-combo-box-t21343/)

n747 13Mar2010 15:16

3 dependable combo box problem
 
Hi,
here I have a issue regading 3 dependable combo box ....Please Help me...
:nonod::nonod:

I created three dependable combo boxes as follows.but when country select all hotels
showed due to country.really I need when select country shows related city and
when select city shows related hotels...So,Please give me a solution .

----------------java script -----------------------------------
Code:

function selectcountry(){

var selected_index = document.getElementById('country').selectedIndex;
var selected_value = document.getElementById('country').options[selected_index].value;
if(selected_value !='0'){
window.location = 'index.php?c_id='+ selected_value;
}
}

---------------------------------------------------------
Code:

<table width="64%" border="0" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<tr>
<td width="43%"><img src="images/logo.gif" width="273" height="81" /></td>
<td width="43%" valign="top"> <div align="justify"><span class="style1">Srilanka.com travel professionals are fully &quot;in the know&quot; about all the places to go, things to do and special offers to Sri Lanka &amp; Maldives. They are trained and qualified and are very keen to help organize and book your perfect holiday. </span></div></td>
<td width="14%"><div align="center"><img src="images/flower_sri.jpg" width="62" height="66" /></div></td>
</tr><form id="form1" name="form1" method="post" action="selecttype.php">
<tr>
<td><em><strong>Quick Search </strong></em></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Country</div></td>
<td><label>
<select name="country" id="country" onChange="selectcountry()">
<option value="">Select a Country</option>
<?php
$result = mysql_query("select * from country ORDER BY cname ASC");

while($data = mysql_fetch_array($result)){
$cid = $data['cid'];
$_SESSION['country id'] = $countryid;
$cname = $data['cname'];
if($_GET['c_id']== $cid){
?>
<option selected="selected" value="<?php echo $cid; ?>"><?php echo $cname ?></option>
<?php
}else{
?>
<option value="<?php echo $cid; ?>"><?php echo $cname ?></option>
<?php
}
}
?>
</select>
</label></td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="26"><div align="right">City</div></td>
<td><label>
<select name="city" id="city">
<option value="">Select a City</option>
<?php
if(isset($_GET['c_id']))
{
$cid = $_GET['c_id'];
$result2 = mysql_query("select * from city where cid = $cid ");
while($data2 = mysql_fetch_array($result2)){
$cityid = $data2['cityid'];
$_SESSION['city id'] = $cityid;
$city_name = $data2['city_name'];
if($_GET['c_id']== $cityid){
?>
<option selected="selected" value="<?php echo $cityid; ?>"><?php echo $city_name ?></option>
<?php
}else{
?>
<option value="<?php echo $cityid; ?>"><?php echo $city_name ?></option>
<?php
}
}
?>
</select>
<?php
}
?>
</label></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="right">Hotel Name </div></td>
<td><label><select name="hotel" id="hotel">
<option value="">Select a Hotel</option>
<?php
if(isset($_GET['c_id']))
{
$ciid = $_GET['c_id'] ;
echo $ciid;
$result3 = mysql_query("select * from hotel where cid = $ciid "); ///here it must be comes due to city id not country id.....but noe it comes due to country
while($data3 = mysql_fetch_array($result3)){
$hotelid = $data3['hid'];
$_SESSION['hotelid'] = $hotelid ;
$hotelname = $data3['hname'];
?>
<option value="<?php echo $hotelid; ?>"><?php echo $hotelname; ?></option>
<?php
}


?>
</select>
<?php
}
?>
</label></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><label>
<input type="submit" name="submit" value="Find a Hotel" />
</label></td>
</table>

--------------Database-----------
Code:

INSERT INTO `country` (`cid`, `cname`) VALUES
(1, 'UK'),
(2, 'USA');

------------------
INSERT INTO `city` (`cityid`, `cid`, `city_name`) VALUES
(1, 1, 'uuuuu'),
(2, 1, 'tttttt'),
(3, 1, 'dsss'),
(4, 1, 'dfggdgg'),
(5, 2, 'AAAAA'),
(6, 2, 'BBBBBB');

------------
CREATE TABLE IF NOT EXISTS `hotel` (
`hid` int(10) NOT NULL AUTO_INCREMENT,
`cid` int(10) NOT NULL,
`cityid` int(10) NOT NULL,
`hname` varchar(50) NOT NULL,
`haddress` text NOT NULL,
`hemail` varchar(50) NOT NULL,
`htelno` varchar(20) NOT NULL,
`hlocation` text NOT NULL,
`hdining` text NOT NULL,
`h_con_person` varchar(30) NOT NULL,
`hspecial` text NOT NULL,
`hfax` varchar(30) NOT NULL,
PRIMARY KEY (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

Pls I need Someone help.......Thanks In Advanced


All times are GMT +5.5. The time now is 06:10.