alanl1 Posted May 3, 2013 Share Posted May 3, 2013 (edited) Hi Professionals I have the following 2 pages, in the welcome.php I am trying to retreive the TowerSelect drop downs value to echo in the page but it is only showing TowerSelect not the actual value. Where could I be going wrong thanks <html></body><form action="welcome.php" method="POST">Please select the manufacturer you wish to report on. </br></br> <select name="TowerSelect"><option> Choose </option> <?php $server='d3licsql02';$connectinfo=array("Database"=>"TestData", "UID" => "sa", "PWD" => "SECRET"); //connect to DB$conn=sqlsrv_connect($server,$connectinfo); if( $conn === false ) { die( print_r( sqlsrv_errors(), true));} $sql = "SELECT distinct software_manufacturer FROM softusecomp";$sql1 = "SELECT distinct software_manufacturer, product,product_version,path FROM softusecomp";$stmt = sqlsrv_query( $conn, $sql); if( $stmt === false) { die( print_r( sqlsrv_errors(), true) );} while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) { echo "<option value=";echo "'".$row['software_manufacturer']."'";echo ">";echo $row['software_manufacturer'];echo "</option>"; } sqlsrv_free_stmt( $stmt); ?></select> <input type="submit" value="Search"></br></br></form></body></html> -------------------------------------------------------------------------------------------- <html></body><form action="filter.php" method="POST">Report for -Insert manufacturer name here-. </br></br>TowerSelect <?php $server='d3licsql02';$connectinfo=array("Database"=>"TestData", "UID" => "sa", "PWD" => "SECRET"); //connect to DB$conn=sqlsrv_connect($server,$connectinfo); if( $conn === false ) { die( print_r( sqlsrv_errors(), true));} $manufacturer_name = $_GET['TowerSelect']; echo $manufacturer_name; $sql = "SELECT top 100 software_manufacturer, product,product_version,path FROM softusecomp where software_manufacturer = 'Microsoft Corporation'";$stmt = sqlsrv_query( $conn, $sql); if( $stmt === false) { die( print_r( sqlsrv_errors(), true) );} while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) { echo $row['software_manufacturer'].", ".$row['product'].", ".$row['product_version'].", ".$row['path']."<br />"; } sqlsrv_free_stmt( $stmt); ?> <input type="submit" value="filter"></br></br></form></body></html> Edited May 3, 2013 by alanl1 Quote Link to comment Share on other sites More sharing options...
Solution DaveyK Posted May 3, 2013 Solution Share Posted May 3, 2013 (edited) Please put your code in code blocks (identified by the "<>" icon on the top) and seperate them by file. Also, please only show relevant code. Looking at your code real quickly I noticed there is a difference in methods. Both <forms> have method="POST" but you are using $_GET['towerSelect']. might I suggest that you perform most of your PHP (including ESPECIALLY queries) above the HTML. This code is really hard to read. Also, is error reporting turned on? Edited May 3, 2013 by DaveyK Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.