nucleardoctor Posted May 3, 2007 Share Posted May 3, 2007 When I go to load this page, the first drop down box works and it loads everyones names, but every drop down box after the first one won't load anyones names, it just says select member. Did I forget to end the first one or something? <? include "connect.phtml"; $db=delranfire_org; if(isset($_POST['select'])){ }//end if $query="select name from member order by name asc"; $rows=mysql_db_query($db,$query,$connection) or die("Error in query:$query. " .mysql_error()); ?> <html> <head> <title> <? include "admin_panel_title.php";?> </title> </head> <body bgcolor="#000000" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FF3333" vlink="#CC0000" alink="#CC0000"> <form action="231officers.phtml" method="post"> <center> <img src="/newadmin/Administration_Panel_Banner.png"><br> <h3>Station 231 Officers</h3> <table border="1" cellspacing="0" cellpadding="0" align="center"> <tr> <td colspan="2"> <center> <I>Line Officers</I> </center> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Deputy Chief (2310): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Captain (2301): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>1st Lieutenant (2303): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>2nd Lieutenant (2305): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Chief Engineer: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Asst. Engineers (5): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Fire Police Captain: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Fire Police Lieutenant: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td colspan="2"> <center> <I>Administrative Officers</I> </center> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>President: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Vice President: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Treasurer: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Financial Secretary: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Corresponding Secretary: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Trustees (3): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td colspan="3"> <div align="center"> <input type="submit" name="Submit" value="Update"> <input type="reset" name="reset" value="Clear Information"> </div> </td> </tr> </table> </form> <a href="/newadmin/">Back to Administration Panel</a> </body></html> <? mysql_close(); ?> Quote Link to comment Share on other sites More sharing options...
thedarkwinter Posted May 3, 2007 Share Posted May 3, 2007 Hi After a quick look i noticed that all you selects have the same name... this might be affecting it ?? (i cant think off hand if it does???) Cheers, tdw Quote Link to comment Share on other sites More sharing options...
thedarkwinter Posted May 3, 2007 Share Posted May 3, 2007 ... also you may want to try adding mysql_data_seek($rows,0); before the while loops to reset the pointer. Quote Link to comment Share on other sites More sharing options...
nucleardoctor Posted May 3, 2007 Author Share Posted May 3, 2007 Where should I put the mysql_data_seek($rows,0); ? After every dropdown box?  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> Quote Link to comment Share on other sites More sharing options...
thedarkwinter Posted May 3, 2007 Share Posted May 3, 2007 Preferably before the line (from the second box onward...) but that should be fine how you have got it. I have't used that function before, i just know of it think it works?? Quote Link to comment Share on other sites More sharing options...
nucleardoctor Posted May 3, 2007 Author Share Posted May 3, 2007 So then  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> mysql_data_seek($rows,0);  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> mysql_data_seek($rows,0);  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> Quote Link to comment Share on other sites More sharing options...
thedarkwinter Posted May 3, 2007 Share Posted May 3, 2007 No it need to be inside the <??> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> Quote Link to comment Share on other sites More sharing options...
nucleardoctor Posted May 3, 2007 Author Share Posted May 3, 2007 Ok, the displaying works but now when I click submit, all it writes to the database is 'Select Member' It doesn't write the people I select... hmm. <? include "connect.phtml"; $db=delranfire_org; if(isset($_POST['select'])){ $query1="insert into 231officers(name)values('$select')"; mysql_db_query($db,$query1,$connection) or die("Error in query:$query. " .mysql_error()); }//end if $query="select name from member order by name asc"; $rows=mysql_db_query($db,$query,$connection) or die("Error in query:$query. " .mysql_error()); ?> <html> <head> <title> <? include "admin_panel_title.php";?> </title> </head> <body bgcolor="#000000" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FF3333" vlink="#CC0000" alink="#CC0000"> <form action="231officers.phtml" method="post"> <center> <img src="/newadmin/Administration_Panel_Banner.png"><br> <h3>Station 231 Officers</h3> <table border="1" cellspacing="0" cellpadding="0" align="center"> <tr> <td colspan="2"> <center> <I>Line Officers</I> </center> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Deputy Chief (2310): </b></div> </td> <td width="51%" valign="middle">  <select name="name"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Captain (2301): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>1st Lieutenant (2303): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>2nd Lieutenant (2305): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Chief Engineer: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Asst. Engineers (5): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Fire Police Captain: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Fire Police Lieutenant: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td colspan="2"> <center> <I>Administrative Officers</I> </center> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>President: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Vice President: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Treasurer: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Financial Secretary: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Corresponding Secretary: </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Trustees (3): </b></div> </td> <td width="51%" valign="middle">  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br>  <select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td colspan="3"> <div align="center"> <input type="submit" name="Submit" value="Update"> <input type="reset" name="reset" value="Clear Information"> </div> </td> </tr> </table> </form> <a href="/newadmin/">Back to Administration Panel</a> </body></html> <? mysql_close(); ?> Quote Link to comment Share on other sites More sharing options...
thedarkwinter Posted May 4, 2007 Share Posted May 4, 2007 Okay i just crawled out of bed about 10 minutes ago... so forgive me if i sound like it! I dont really know mysql method you are using, but i think it irrelevant. You are checking if post exists and then not really using it in the sql. <?php if(isset($_POST['select'])) { $select = $_POST["select"]; // read this var from post or else the next line has an empty var $query1="insert into 231officers(name)values('$select')"; mysql_db_query($db,$query1,$connection) or die("Error in query:$query. " .mysql_error()); } cheers, tdw 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.