DaniWeb Forum Index > Web Development > PHP

please help me in drop down list

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: May 2008

Posts: 28

Reputation: almualim is an unknown quantity at this point

Solved Threads: 0

almualim

Offline

Light Poster

Re: please help me in drop down list

#11

May 8th, 2008

hi, ok i tried to print this value: $firstdropdownlistvalue = $_POST['col_name'];
by echo($firstdropdownlistvalue);
but it's doesn't appeared in the browser. why?

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: please help me in drop down list

#12

May 8th, 2008

Post your latest code.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: May 2008

Posts: 28

Reputation: almualim is an unknown quantity at this point

Solved Threads: 0

almualim

Offline

Light Poster

Re: please help me in drop down list

#13

May 8th, 2008

okay:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
            mysql_connect ("localhost","root","");
            mysql_select_db ("University");
 
            $firstdropdownlistvalue = $_POST['col_name'];
 
            $get_list_result = mysql_query("select Col_Name from College");
 
 echo '<form name="delete" method="POST" action="delete_dept2.php">';
 
echo'<select name=col_name onchange=javascript: document.delete.submit(); style="position:absolute;left:311px;top:146px;width:303px;z-index:2">';
while ($recs = mysql_fetch_array($get_list_result)){
 
            $display_list =  $recs['Col_Name'];
if($display_list==$firstdropdownlistvalue){
 $selected = "selected";
}
else
{ $selected = ""; 
}     
echo "<option value='".$display_list."' $selected>" .$display_list."</option>";
           }
echo "</select>";
echo ($firstdropdownlistvalue);
 
$get_list_result2 = mysql_query("select * from College where Col_Name='$firstdropdownlistvalue'");
$get_list_result3=  mysql_query("select D_Name from Department where Col_No='$get_list_result2'");
 
echo'<select name="formselect2" style="position:absolute;left:310px;top:223px;width:308px;z-index:4">';
while ($recs2 = mysql_fetch_array($get_list_result3)){
 
            $display_list2 =  $recs2['D_Name'];
 
           echo "<option value='".$display_list2."'> $display_list2 </option>";
           }
echo '</select>';
?>
<?php
            mysql_connect ("localhost","root","");
            mysql_select_db ("University");
             
            $firstdropdownlistvalue = $_POST['col_name'];

            $get_list_result = mysql_query("select Col_Name from College");

 echo '<form name="delete" method="POST" action="delete_dept2.php">';

echo'<select name=col_name onchange=javascript<b></b>: document.delete.submit(); style="position:absolute;left:311px;top:146px;width:303px;z-index:2">';
while ($recs = mysql_fetch_array($get_list_result)){
           
            $display_list =  $recs['Col_Name'];
if($display_list==$firstdropdownlistvalue){
 $selected = "selected";
}
else
{ $selected = ""; 
}     
echo "<option value='".$display_list."' $selected>" .$display_list."</option>";
           }
echo "</select>";
echo ($firstdropdownlistvalue);

$get_list_result2 = mysql_query("select * from College where Col_Name='$firstdropdownlistvalue'");
$get_list_result3=  mysql_query("select D_Name from Department where Col_No='$get_list_result2'");

echo'<select name="formselect2" style="position:absolute;left:310px;top:223px;width:308px;z-index:4">';
while ($recs2 = mysql_fetch_array($get_list_result3)){
           
            $display_list2 =  $recs2['D_Name'];
     
           echo "<option value='".$display_list2."'> $display_list2 </option>";
           }
echo '</select>';
?>

Last edited by peter_budo; May 11th, 2008 at 11:19 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: please help me in drop down list

#14

May 8th, 2008

onchange="javascript: document.delete.submit();" instead of
onchange=javascript: document.delete.submit();

Secondly,

•

$get_list_result2 = mysql_query("select * from College where Col_Name='$firstdropdownlistvalue'");
$get_list_result3= mysql_query("select D_Name from Department where Col_No='$get_list_result2'");

is wrong. What are you trying to do ?

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: May 2008

Posts: 28

Reputation: almualim is an unknown quantity at this point

Solved Threads: 0

almualim

Offline

Light Poster

Re: please help me in drop down list

#15

May 8th, 2008

see the last update on the code:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
            mysql_connect ("localhost","root","");
            mysql_select_db ("University");
 
            $firstdropdownlistvalue = $_POST['col_name'];
 
            $get_list_result = mysql_query("select Col_Name from College");
 
 echo '<form name="delete" method="POST" action="delete_dept2.php">';
 
echo'<select name=col_name onchange="javascript: document.delete.submit();" style="position:absolute;left:311px;top:146px;width:303px;z-index:2">';
while ($recs = mysql_fetch_array($get_list_result)){
 
            $display_list =  $recs['Col_Name'];
if($display_list==$firstdropdownlistvalue){
 $selected = "selected";
}
else
{ $selected = ""; 
}     
echo "<option value='".$display_list."' $selected>" .$display_list."</option>";
           }
echo "</select>";
echo ($firstdropdownlistvalue);
 
$get_list_result2 = mysql_query("select col_No from College where Col_Name='$firstdropdownlistvalue'");
while ($recs2 = mysql_fetch_array($get_list_result2)){
 
            $display_list2 =  $recs2['col_No'];
}
 
 
 
$get_list_result3=  mysql_query("select D_Name from Department where Col_No='$$display_list2'");
 
echo'<select name="formselect2" style="position:absolute;left:310px;top:223px;width:308px;z-index:4">';
while ($recs3 = mysql_fetch_array($get_list_result3)){
 
            $display_list3 =  $recs3['D_Name'];
 
           echo "<option value='".$display_list3."'> $display_list3 </option>";
           }
echo '</select>';
?>
<?php
            mysql_connect ("localhost","root","");
            mysql_select_db ("University");
             
            $firstdropdownlistvalue = $_POST['col_name'];

            $get_list_result = mysql_query("select Col_Name from College");

 echo '<form name="delete" method="POST" action="delete_dept2.php">';

echo'<select name=col_name onchange="javascript<b></b>: document.delete.submit();" style="position:absolute;left:311px;top:146px;width:303px;z-index:2">';
while ($recs = mysql_fetch_array($get_list_result)){
           
            $display_list =  $recs['Col_Name'];
if($display_list==$firstdropdownlistvalue){
 $selected = "selected";
}
else
{ $selected = ""; 
}     
echo "<option value='".$display_list."' $selected>" .$display_list."</option>";
           }
echo "</select>";
echo ($firstdropdownlistvalue);

$get_list_result2 = mysql_query("select col_No from College where Col_Name='$firstdropdownlistvalue'");
while ($recs2 = mysql_fetch_array($get_list_result2)){
           
            $display_list2 =  $recs2['col_No'];
}



$get_list_result3=  mysql_query("select D_Name from Department where Col_No='$$display_list2'");

echo'<select name="formselect2" style="position:absolute;left:310px;top:223px;width:308px;z-index:4">';
while ($recs3 = mysql_fetch_array($get_list_result3)){
           
            $display_list3 =  $recs3['D_Name'];
     
           echo "<option value='".$display_list3."'> $display_list3 </option>";
           }
echo '</select>';
?>

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$get_list_result2 = mysql_query("select col_No from College where Col_Name='$firstdropdownlistvalue'");
$get_list_result2 = mysql_query("select col_No from College where Col_Name='$firstdropdownlistvalue'");

here i want to get college_no(col_No) from college table, if the college name(col_Name) equals the value came from 1st dropdown list($firstdropdownlistvalue)

$get_list_result3= mysql_query("select D_Name from Department where col_No='$display_list2'");

and here i want to get department name(D_Name) from Department table, if college_no(col_No) equals $display_list2

Last edited by peter_budo; May 11th, 2008 at 11:20 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: please help me in drop down list

#16

May 8th, 2008

Then use a sub query.

Help with Code Tags

php Syntax (Toggle Plain Text)

$query = "select D_Name from Department where col_No = (select col_No from College where col_name = '$firstdropdownlistvalue')";

This will return the D_name of the selected col_name.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: May 2008

Posts: 28

Reputation: almualim is an unknown quantity at this point

Solved Threads: 0

almualim

Offline

Light Poster

Re: please help me in drop down list

#17

May 8th, 2008

Tired with me, but the problem still exist and I do not know what to do...

Last edited by almualim; May 8th, 2008 at 9:37 am.

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: please help me in drop down list

#18

May 8th, 2008

Use firefox to execute your scripts. Make use of error console to see any javascript error.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: May 2008

Posts: 28

Reputation: almualim is an unknown quantity at this point

Solved Threads: 0

almualim

Offline

Light Poster

Re: please help me in drop down list

#19

May 8th, 2008

i tried with firefox, but when i was select value from 1st dropdown list Transmission occurs for the second page, but i want the values appear in the same page.