Dynamic Select Box - Codewalkers

Codewalkers Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

July 14th, 2004, 07:33 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

Dynamic Select Box

Dear All:

Dear All:

Anybody could advices me on this.

On my page, there are 2 option selector. 1 for category and 1 for subcategory.

The category option selector coding as below:

<SCRIPT LANGUAGE="JavaScript">
function CategorySelected(form)
{

// dynamic subcategory select box

}
</script>
<form name=f1 method=post action="act_uploadpic.php" enctype=multipart/form-data target=_self >
Picture Name: <input type=text maxlength=25 name=pname size="50"><br>
<input type=hidden name=PIC_FILE_SIZE value=100000>
Category:        <SELECT NAME=category ONCHANGE="CategorySelected(this)";>

php Code:

Original - php Code

 
 
php include("list_var.php"); 
 
$db = mysql_connect($server,$dbuser,$dbpasswd); 
mysql_select_db($dbname); 
 
$sqlcat;  
$sqlsub; 
 
$result = mysql_query($sqlcat); 
 
if (!$result) { 
    echo "Could not successfully run query ($sqlcat) from DB: " . mysql_error(); 
    exit; 
} 
 
if (mysql_num_rows($result) == 0) { 
    echo "No rows found, nothing to print so am exiting"; 
    exit; 
} 
while ($row = mysql_fetch_assoc($result)) { 
     
    echo "<OPTION>"; 
    echo $row["category"]; 
    echo "</OPTION>"; 
 
} 
mysql_free_result($result); 
 
    echo "</select>"; 
    echo "<br>";

The tables structure to capture the category, subcategory and catedory_subcategory table as belows:

category:
id
category
description

subcategory
id
subcategory
description

maincat_subcat
category
subcategory

What i want is, when user change the category code on the option selector. It will dynamically retrieve(from DB) subcategory belong to the select category

Thanks

Viewing: Codewalkers Forums > Other Technologies > Client Side Things > Dynamic Select Box

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump