select statement not pulling up all records

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Obadiah
Forum Regular
Posts: 580
Joined: Mon Jul 31, 2006 9:13 am
Location: Ashland, KY
Contact:

select statement not pulling up all records

Post 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
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: select statement not pulling up all records

Post by John Cartwright »

You need to put your outlogic logic inside your while loop.
Post Reply