Page 1 of 1

select statement not pulling up all records

Posted: Wed Oct 20, 2010 11:37 am
by Obadiah
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

Code: Select all

if ($_SESSION['user_id']){
$display_block .="
<form action=\"$postIt\" method=\"post\">
<b>Choose a department to review:</b>&nbsp;
<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>

";
 
thanks a million in advance folks

Re: select statement not pulling up all records

Posted: Wed Oct 20, 2010 11:54 am
by John Cartwright
You need to put your outlogic logic inside your while loop.