What I'm looking at:
Code: Select all
$supervisee = mysql_query("SELECT * FROM tblEmployee WHERE DEPARTMENT = '" . $Dept . "'");
while($results = mysql_fetch_array($supervisee)) {
foreach ($results as $temp) {
echo $temp . " ";
}
echo "<br />";
} Code: Select all
Array ( [0] => 8******* [ID] => 8******* [1] => M***** [LAST_NAME] => M***** [2] => A***** [FIRST_NAME] => A***** [3] => M [MIDDLE_NAME] => M [4] => IT [DEPARTMENT] => IT [5] => HERE [LOCATION] => HERE ) Hmm.. I still get numerical and associative indexing...
Code: Select all
while($rowSupervisee = mysql_fetch_assoc($supervisee)){
for($i=0; $i < mysql_num_rows($supervisee); $i++) {
foreach ($rowSupervisee as $temp) {
echo $temp;
}
echo "<br />";
}
}