Ad:

PHP Discussion Thread
Unsolved
Views: 2941

You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page

May 8th, 2008

Re: please help me in drop down list

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?

almualim

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since May 2008

Permalink

May 8th, 2008

Re: please help me in drop down list

Post your latest code.

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

May 8th, 2008

Re: please help me in drop down list

okay:

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

almualim

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since May 2008

Permalink

May 8th, 2008

Re: please help me in drop down list

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

Secondly,

Quote ...

$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 ?

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

May 8th, 2008

Re: please help me in drop down list

see the last update on the code:

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>';
?>

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

almualim

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since May 2008

Permalink

May 8th, 2008

Re: please help me in drop down list

Then use a sub query.

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.

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

May 8th, 2008

Re: please help me in drop down list

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.

almualim

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since May 2008

Permalink

May 8th, 2008

Re: please help me in drop down list

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

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

May 8th, 2008

Re: please help me in drop down list

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.

almualim

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since May 2008

Permalink

May 8th, 2008

Re: please help me in drop down list

What second page ? Why dont you keep everything in the same page ?

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Previous
1
Page 2
3
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Refresh + Combo Box

Next Thread in PHP Forum Timeline: need php codings for my task!

DaniWeb Message

Cancel Changes

User Name
Password