switch not getting value


Posted on 16th Feb 2014 07:03 pm by admin

what am i doing wrong?
i want to populate the country list according to the category
i want to switch in case CategoryID=1 and CatID2=2 in the country_list table

then call on "alpha" to populate the dropdown list via ajax
the form:
Code: <!--
The following file was created by Iwo Kadziela at TECHROAM: http://www.techroam.com
This file uses MySql database and AJAX to create autopopulating dynamic select boxes.

<html>
<head>
<script src="request.js"></script>
<script type="text/javascript">

function getfirst(dd1)
{
clearSelect = document.getElementById('thirdbox');
clearSelect.options.length = 1;
//above code clears the third select box when re-clicking the first select box

var idx = dd1.selectedIndex;
var first = dd1[idx].value;
var par = document.forms["theform"];
var parelmts = par.elements;
var prezsel = parelmts["secondbox"];
if (first != "Select Something One")
{
Http.get({
url: "./alpha.php?alpha=" + first + "%",
callback: fillPrez,
cache: Http.Cache.Get
}, [prezsel]);
}
}

function getsecond(dd1)
{
var idx = dd1.selectedIndex;
var second = dd1[idx].text;
var par = document.forms["theform"];
var parelmts = par.elements;
var prezsel = parelmts["thirdbox"];
if (second != "Select Something Two")
{
Http.get({
url: "./beta.php?state=" + second,
callback: fillPrez,
cache: Http.Cache.Get
}, [prezsel]);
}
}

function fillPrez(xmlreply, prezelmt)
{
if (xmlreply.status == Http.Status.OK)
{
var prezresponse = xmlreply.responseText;
var prezar = prezresponse.split("|");
prezelmt.length = 1;
prezelmt.length = prezar.length;
for (o=1; o < prezar.length; o++)
{
prezelmt[o].text = prezar[o];
prezelmt[o].value = prezar[o];
}
}
else
{
alert("Cannot handle the AJAX call.");
}
}

function getthird(dd1,dd2) {
var idx = dd1.selectedIndex;
var third = dd1[idx].text;
if (third != "Select The Final")
{
Http.get({
url: "./final.php?state=" + dd2 + "&city=" + third,
callback: getit,
cache: Http.Cache.Get
});
}
}

function getit(xmlreply){
if (xmlreply.status == Http.Status.OK)
{
document.getElementById("final").innerHTML= xmlreply.responseText;
}
else
{
alert("Cannot handle the AJAX call.");
}
}
</script>
<style>
body {
width:800px;
margin: 0px auto;
text-align:center;
}
p {display:inline;margin:20px;}
div {clear:both;width:800px;border:1px solid #999;padding:20px;margin:20px 0px 20px 0px;}
</style>
</head>

<body>

<form name="theform">
<p>
<select name="firstbox" size="13" style="position: relative; width: 215px;" onChange="getfirst(this);">
<option value="">Select Something One</option>
<?php
do {
?>
<option value="<?php echo $row_RsCategories['CategoryID']?>"><?php echo $row_RsCategories['CategoryName']?></option>
<?php
} while ($row_RsCategories = mysql_fetch_assoc($RsCategories));
$rows = mysql_num_rows($RsCategories);
if($rows > 0) {
mysql_data_seek($RsCategories, 0);
$row_RsCategories = mysql_fetch_assoc($RsCategories);
}
?>
</select>
</p>
<p>
<select name="secondbox" size="13" style="position: relative; width: 215px;" onChange="getsecond(this);">
<option>Select Something Two</option>
</select>
</p>
<p>
<select id="thirdbox" name="thirdbox" size="13" style="position: relative; width: 215px;" onChange="getthird(this, document.theform.secondbox.options[document.theform.secondbox.selectedIndex].value);">
<option>Select The Final</option>
</select>
</p>
</form>
<center>THE FINAL CONTENT PULLED FROM DATABASE</center>
<div id="final"></div>
</body>
</html>
<?php
mysql_free_result($RsCategories);
?>

alpha.php
Code: </php
$dbconnection = mysql_connect ("localhost", "root", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("international", $dbconnection) or die("Couldn't open database: ".mysql_error());
$alpha=$_GET['alpha'];
switch ($alpha)
{
case 1:
$result = mysql_query("SELECT CountryName from country_list WHERE CategoryID = '".$_GET['alpha']."'");
break;
case 2:
$result = mysql_query("SELECT CountryName from country_list WHERE CatID2 = '".$_GET['alpha']."'");
break;


while ($row = mysql_fetch_array($result)) {
echo "|" . $row['CountryName'];
}

?>

No comments posted yet

Your Answer:

Login to answer
97 Like 15 Dislike
Previous forums Next forums
Other forums

insert PHP code into function
Hi,
I'm having problems when trying following:

I have:
Code: [Select]createBar("Do

php mailer
How can i send a mail to large no, say 50,000 reciepients using [color=#0000FF]php mailer[/color]

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

this code is strange !
Hi i got this code from the web.. It checks for live and dead socks
It is working perfectly on my

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

Auto install
Hi I have a directory lets say "apps" that I then have more folders ie "email",

Array to string conversion
Can anyone help me with this?

Notice: Array to string conversion in /home/..../index.php on l

Default TimeZone
The server I'm working with is hosted in America so all times inserted into the database are coming

can i optmize image to 50% quality before uploading 2 server
Hi there

i have jus written a php program to upload and display images but when i try to uplo

Help with forum quoting?
Hi im working on a forum and I have alomost finished it but i want a user quote system like twitter

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash