kendris Posted March 25, 2013 Share Posted March 25, 2013 <html> <?php include "overallheader.php" ?> <div id ='container'> <div id ='content'> <div id='navBar'> <?php include "navbar.php"?> </div> <div id='userinfo'> <?php session_start(); if (isset($_SESSION['username'])) { $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("login", $con); mysql_close($con); } else die("You must be logged in <a href='index.php'>Back</a>"); ?> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("login", $con); $result=mysql_query('SELECT eventname FROM event'); $result = mysql_query("SELECT * FROM event"); ?> </div> <select name="listbox" size="5" onchange> <?php $tester=mysql_query('SELECT eventname FROM event ORDER BY eventname ASC'); while($row = mysql_fetch_array($tester)) { echo "<option>" . $row['eventname'] . "</option>" ; } ?> </select> <select name="price" size="5"> </select> <select name="price" size="5"> <?php $location=mysql_query('SELECT location FROM event'); while($row = mysql_fetch_array($location)) { echo "<option>" . $row['location'] . "</option>" ; } ?> </div> </div> </html> Basically I'm looking for a way to make this dynamic, so if an option from the first select it will display options in a second table but for each select it will generate the correct listings. 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.