select statement not pulling up all records
Posted: Wed Oct 20, 2010 11:37 am
i have a very strage error happening....i have a dropdown that when i select a area it post the data from that area from the database...the issue is...it actually post the data...however if you have more than one record for that department it will not post them all should my select be made differently
thanks a million in advance folks
Code: Select all
if ($_SESSION['user_id']){
$display_block .="
<form action=\"$postIt\" method=\"post\">
<b>Choose a department to review:</b>
<select name=\"area\" onchange=\"this.form.submit();\">
<option> </option>
<option>Behm</option>
<option>BronchLab</option>
<option>C/SParkPlace</option>
<option>CARehab</option>
<option>Cath/VascLab</option>
<option>CDU1</option>
<option>CDU2</option>
<option>CI</option>
<option>CT</option>
<option>CVICU</option>
<option>CVOR</option>
<option>Diag Rad</option>
<option>Dismissal</option>
<option>ED</option>
<option>Endoscopy</option>
<option>FCC</option>
<option>FCCG.Rad</option>
<option>FCCGrayson</option>
<option>FCCOliveHill</option>
<option>Food Service</option>
<option>G.OR</option>
<option>GiftShop</option>
<option>HVCPre-Op</option>
<option>HVCProcedureRoom</option>
<option>HVCP</option>
<option>HVIU</option>
<option>HVRU</option>
<option>HVSD</option>
<option>HVSU</option>
<option>ICU</option>
<option>ICUOF</option>
<option>IMU</option>
<option>KDMC</option>
<option>LAB</option>
<option>LDR</option>
<option>MedicalRecords</option>
<option>MEDO</option>
<option>MOU</option>
<option>MRI</option>
<option>N.MED</option>
<option>NurologyDept.</option>
<option>NICU</option>
<option>NRSY</option>
<option>NSC</option>
<option>NVCProcedureRoom</option>
<option>OBGY</option>
<option>OIV</option>
<option>ONCO</option>
<option>OPT</option>
<option>OR</option>
<option>OSC</option>
<option>OSU</option>
<option>PAT</option>
<option>PEDS</option>
<option>Pharmacy</option>
<option>QM</option>
<option>RAD</option>
<option>REHAB</option>
<option>RSTD</option>
<option>SDS/PACU</option>
<option>SPC</option>
<option>SRU</option>
<option>SurgicalServices</option>
<option>SURO</option>
<option>TCU</option>
<option>Ultra</option>
<option>Urology Clinic</option>
<option>WoundCare</option>
</select>
</form>
";
$areaSelected = $_POST['area'];
$conn = doDB();
$sql = "Select * FROM data WHERE Area = '{$areaSelected}'";
$result = mysql_query($sql,$conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result))
{
$realdate = $newArray['Date'];
$DMonth = $newArray['Month'];
$DYear = $newArray['Year'];
$areaReported = $newArray['Area'];
$percent1 = $newArray['percent1'];
$percent2 = $newArray['percent2'];
$percent3 = $newArray['percent3'];
$percent4 = $newArray['percent4'];
$percent5 = $newArray['percent5'];
$percent6 = $newArray['percent6'];
$percent7 = $newArray['percent7'];
$percent8 = $newArray['percent8'];
$percent9 = $newArray['percent9'];
$percent10 = $newArray['percent10'];
$percent11 = $newArray['percent11'];
$percent12 = $newArray['percent12'];
$percent13 = $newArray['percent13'];
$percent14 = $newArray['percent14'];
$percent15 = $newArray['percent15'];
$percent16 = $newArray['percent16'];
$percent17 = $newArray['percent17'];
$percent18 = $newArray['percent18'];
$percent19 = $newArray['percent19'];
$percent20 = $newArray['percent20'];
$percent21 = $newArray['percent21'];
$percent22 = $newArray['percent22'];
$percent23 = $newArray['percent23'];
$percent24 = $newArray['percent24'];
$percent25 = $newArray['percent25'];
$percent26 = $newArray['percent26'];
$percent27 = $newArray['percent27'];
$percent28 = $newArray['percent28'];
$percent29 = $newArray['percent29'];
$percent30 = $newArray['percent30'];
$percent31 = $newArray['percent31'];
$percent32 = $newArray['percent32'];
$numSedated = $newArray['numSedated'];
$numComplications = $newArray['numComplications'];
$numReversalAgent = $newArray['numReversalAgent'];
}
include("../txtdefine.inc");
if ($areaSelected == $areaReported)
{
$display_block .="
<div class=\"display\">
<table border=\"1\" bordercolor=\"white\" width=\"700px\" style=\"color:dcdde2\">
<tr style=\"color:313b65; background-color:white;\">
<td colspan=\"4\"><b>$areaReported</b></td>
</tr>
<tr style=\"color:313b65; background-color:white;\">
<td>$DMonth</td><td>$DYear</td>
</tr>
<tr style=\"color:313b65; background-color:white;\">
<td colspan=\"4\">Submitted on $realdate</td>
</tr>
<tr style=\"color:313b65; background-color:white;\">
<td><b>Question</b></td><td><b>Percent</b></td>
</tr>
<tr>
<td>$question1</td><td>$percent1</td>
</tr>
<tr>
<td>$question2</td><td>$percent2</td>
</tr>
<tr>
<td>$question3</td><td>$percent3</td>
</tr>
<tr>
<td>$question4</td><td>$percent4</td>
</tr>
<tr>
<td>$question5</td><td>$percent5</td>
</tr>
<tr>
<td>$question6</td><td>$percent6</td>
</tr>
<tr>
<td>$question7</td><td>$percent7</td>
</tr>
<tr>
<td>$question8</td><td>$percent8</td>
</tr>
<tr>
<td>$question9</td><td>$percent9</td>
</tr>
<tr>
<td>$question10</td><td>$percent10</td>
</tr>
<tr>
<td>$question11</td><td>$percent11</td>
</tr>
<tr>
<td>$question12</td><td>$percent12</td>
</tr>
<tr>
<td>$question13</td><td>$percent13</td>
</tr>
<tr>
<td>$question14</td><td>$percent14</td>
</tr>
<tr>
<td>$question15</td><td>$percent15</td>
</tr>
<tr>
<td>$question16</td><td>$percent16</td>
</tr>
<tr>
<td>$question17</td><td>$percent17</td>
</tr>
<tr>
<td>$question18</td><td>$percent18</td>
</tr>
<tr style=\"color:313b65; background-color:white;\">
<td colspan=\"2\"><b>H&P:</b> (All patient Care Units/Departments) <b>Review the H&P documented prior to operative
procedure. Does the H&P contain the following required elements?</b></td>
</tr>
<tr>
<td>$question19</td><td>$percent19</td>
</tr>
<tr>
<td>$question20</td><td>$percent20</td>
</tr>
<tr>
<td>$question21</td><td>$percent21</td>
</tr>
<tr>
<td>$question22</td><td>$percent22</td>
</tr>
<tr>
<td>$question23</td><td>$percent23</td>
</tr>
<tr>
<td>$question24</td><td>$percent24</td>
</tr>
<tr>
<td>$question25</td><td>$percent25</td>
</tr>
<tr>
<td>$question26</td><td>$percent26</td>
</tr>
<tr>
<td>$question27</td><td>$percent27</td>
</tr>
<tr>
<td>$question28</td><td>$percent28</td>
</tr>
<tr>
<td>$question29</td><td>$percent29</td>
</tr>
<tr>
<td>$question30</td><td>$percent30</td>
</tr>
<tr>
<td>$question31</td><td>$percent31</td>
</tr>
<tr>
<td>$question32</td><td>$percent32</td>
</tr>
<tr>
<td>$question33</td><td>$numSedated</td>
</tr>
<tr>
<td>$question34</td><td>$numComplications</td>
</tr>
<tr>
<td>$question35</td><td>$numReversalAgent</td>
</tr>
</table>
</div>
</div>";
}
else if ($areaSelected = " "){
$display_block.="nothing to display";
}
}
else
$display_block.= "
<div class=\"log_text\" style=\"\">You are not logged in!<br> <a href=\"index.php\">Click here</a> to log in</div><div class=\"line\"><span class=\"alt\"></span></div>
";