[RESOLVED] drop down menu

auddog

I have been struggling with a way to get my dropdown menu working correctly.

I think passing the variables is my main problem. Here is what I have:

<select name="company" onChange="MM_jumpMenu('parent',this,0)">
                        <option selected>- Click Here -</option>
                        <?php
                        include 'config.php';
                        /*** create a new mysqli object with default database***/
                        $connection = mysqli_connect($hostname, $username, $password, $dbname) or die ("Unable to connect");
                        //create query
                        $sql = "SELECT id, comp_name FROM company";
                        //excute query
                        $result = mysqli_query($connection, $sql) or die ("Error in query: $sql. ".mysqli_error());
                         while(list($id, $comp_name) = mysqli_fetch_array($result))
						   	{
                                echo "<option value=phone_ext.php?id=$id>$comp_name</option>";
							}
                        // close connection
                        mysqli_close($connection);
                       ?>
                    </select>

I'm using the post command to pass the variable to the other page. Here is what my query reads on the redirected page:


    //create query
    $query = "SELECT comp_name, comp_address, comp_city, comp_state, comp_zip,
    comp_tollfree, comp_phone, comp_fax, comp_website, comp_nightbell FROM company where id = '" . $_POST['id'] . "'";

When I jump to my other page it is completely blank. Don't understand that at all.

Thanks for any help you can provide.

stiduck

Have you tried to use the GET method just to check if it sends the ID or if it is in your phone_ext.php file the problem is?

stiduck

auddog

I have tried that but have the same results - a blank page. When I try and pass the variable and even try to get an echo statement to work, it does nothing.

stiduck

What is in the address bar when you get to the blank page and use the GET method?

stiduck

By the way, you may want to get $id[0] instead of $id because of the array

echo "<option value=phone_ext.php?id=$id[0]>$comp_name</option>";

stiduck

auddog

When I make the changes above my url becomes http://intranet/2 - it's doesn't change the to the phone_ext.php?id=200 (i.e.)

auddog

sorry, I didn't refresh my browser before my last post. Before I made any of the changes you sent, my url would be http://intranet/phone_ext.php?id=1

stiduck

Good. I didn't concider the javascript, so I changed the post... sorry!

If you write this in phone_ext.php you get the output: 1 ?

echo $_POST['id'];

You can also try to make a variable like this above your SQL query:

$id = $_POST['$id'];

And change after WHERE in the query with just

id = '$id'

stiduck

auddog

OK here is what I got.

this is my phones.php page (included the whole page (maybe it's something there)):

 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<html>
<head>
	<title>PCE Intranet</title>
	<link href="../includes/pce.css" rel="stylesheet" type="text/css">
</head>

<body BGCOLOR=#FFFFFF topmargin="0" leftmargin="0" marginheight=0 marginwidth=0 rightmargin=0 bottommargin=0>


<?php include 'includes/main_menu.php';?>

<center>

<table border=0 cellpadding=0 cellspacing=0 width=100% vailn=top>
  <!-- server side include leftside nav table -->
    <?php include 'includes/left_nav_pce.php'; ?>
    <!-- end of left side nav -->
    <br><br><div align=center>
    <form name="quick" method="post" action="phone_ext.php">
      <table width="200" border="1" cellpadding="2" cellspacing="0" bordercolor="#666666" bgcolor="#e7f6b9" style='border-collapse: collapse'>
          <br>
          <tr>
            <td bgcolor="#666666">
            <div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Select a Company</strong></font></div>
            </td>
          </tr>
          <tr>
            <td>
              <div align="center">
               <select name="id" onChange="MM_jumpMenu('parent',this,0)">
                    <option selected>- Click Here -</option>
                    <?php
                    include 'config.php';
                    /*** create a new mysqli object with default database***/
                    $connection = mysqli_connect($hostname, $username, $password, $dbname) or die ("Unable to connect");
                    //create query
                    $sql = "SELECT id, comp_name FROM company";
                    //excute query
                    $result = mysqli_query($connection, $sql) or die ("Error in query: $sql. ".mysqli_error());
                     while(list($id, $comp_name) = mysqli_fetch_array($result))
					   	{
                            echo "<option value=phone_ext.php?id=$id>$comp_name</option>";
						}
                    // close connection
                    mysqli_close($connection);
                   ?>
                </select>
              </div>
			 </td>
          </tr>
        </table>
      </div>
    </form>
</table>
</center>
</body>
</html>

Here is my phone_ext.php page:


<?php

echo $_POST['id'];

$id = $_POST['id'];

?>

Here is what I get in my url: http://intranet/phone_ext.php?id=1
and unfortunately my page is still blank.

I really appreciate you taking the time to help me - thanks a bunch.

auddog

Well I figured it out. I didn't have my included statement at the beginning of my page. I wish I would have thought of that earlier. Lesson well learned. It was nice to know that the code I was using was very similiar to what you wrote. I must be making headway.

Thanks for all your help.