Problem with if else if statement

[msimonds]

I am trying to echo out all the students for a class roster and the data is not being retrieved according to my code:

<?php

// Address error handing.
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);


//Setup the datbase connection
include("../include/config.php");
include("../include/opendb.php");
$query = ("
            SELECT teachers.teacher_id, teachers.teacher_name, students.*
            FROM teachers, students
            WHERE teachers.teacher_id = students.teacher_id
            ORDER BY teachers.teacher_name
         ");

$result = mysql_query($query) or die(mysql_error());

$prevkey = "";
// Print out the contents of each row into a table

echo "<table border=\"1\" width=\"100%\">\n";



while($row = mysql_fetch_array($result))
    {
          if ($row['registered'] == 0)  //registered but not approved with a value of "0"
          {
                        echo "<tr>\n";
                                      echo "<td style=\"font: bold; color: #FF0000; background: #eeeeee\" colspan=\"10\"><strong>No teacher Assigned</strong></td>\n";
                                      echo "</tr>\n";
                                      echo "<tr style=\"border: thin solid #eeeeee\">\n";
                                      echo "<td><strong>Student</strong></td>\n";
                                      echo "<td><strong>Birthdate</strong></td>\n";
                                      echo "<td><strong>Age</strong></td>\n";
                                      echo "<td><strong>Address</strong></td>\n";
                                      echo "<td><strong>Father's Name</strong></td>\n";
                                      echo "<td><strong>Mother's Name</strong></td>\n";
                                      echo "<td><strong>Phone Number</strong></td>\n";
                                      echo "<td><strong>Parent's Email</strong></td>\n";
                                      echo "<td><strong>Known Allergies</strong></td>\n";
                                      echo "</tr>\n";

                                  echo "<tr>\n";
                                  echo "<td>{$row['student_fname']}&nbsp;{$row['student_lname']}</td>\n";
                                  echo "<td>{$row['student_bdate']}</td>\n";
                                  echo "<td>{$row['student_age']}</td>\n";
                                  echo "<td>{$row['student_address1']}<br />{$row['student_city']}, {$row['student_state']} {$row['student_zip']}</td>\n";
                                  echo "<td>{$row['student_father']}</td>\n";
                                  echo "<td>{$row['student_mother']}</td>\n";
                                  echo "<td>{$row['student_contact']}</td>\n";
                                  echo "<td><a href=\"mailto:{$row['student_email']}\">{$row['student_email']}</a></td>\n";
                                  echo "<td>{$row['student_allergies']}</td>\n";
                                  echo "<td><a href=\"edit_student.php?id={$row['student_id']}\">Edit</a>&nbsp;<a href=\"delete_student.php?id={$row['student_id']}\">Delete</a></td>\n";
                                  echo "</tr>\n";
      }

      else if($row['teacher_id'] == 0)  //registered, approved, but no teacher assigned
      {
                                  echo "<tr>\n";
                                  echo "<td style=\"font: bold; color: #FF0000; background: #eeeeee\" colspan=\"10\"><strong>Student Registered from Parent, Not Yet Appoved</strong></td>\n";
                                  echo "</tr>\n";
                                  echo "<tr style=\"border: thin solid #eeeeee\">\n";
                                  echo "<td><strong>Student</strong></td>\n";
                                  echo "<td><strong>Birthdate</strong></td>\n";
                                  echo "<td><strong>Age</strong></td>\n";
                                  echo "<td><strong>Address</strong></td>\n";
                                  echo "<td><strong>Father's Name</strong></td>\n";
                                  echo "<td><strong>Mother's Name</strong></td>\n";
                                  echo "<td><strong>Phone Number</strong></td>\n";
                                  echo "<td><strong>Parent's Email</strong></td>\n";
                                  echo "<td><strong>Known Allergies</strong></td>\n";
                                  echo "</tr>\n";

                                  echo "<tr>\n";
                                  echo "<td>{$row['student_fname']}&nbsp;{$row['student_lname']}</td>\n";
                                  echo "<td>{$row['student_bdate']}</td>\n";
                                  echo "<td>{$row['student_age']}</td>\n";
                                  echo "<td>{$row['student_address1']}<br />{$row['student_city']}, {$row['student_state']} {$row['student_zip']}</td>\n";
                                  echo "<td>{$row['student_father']}</td>\n";
                                  echo "<td>{$row['student_mother']}</td>\n";
                                  echo "<td>{$row['student_contact']}</td>\n";
                                  echo "<td><a href=\"mailto:{$row['student_email']}\">{$row['student_email']}</a></td>\n";
                                  echo "<td>{$row['student_allergies']}</td>\n";
                                  echo "<td><a href=\"edit_student.php?id={$row['student_id']}\">Edit</a>&nbsp;<a href=\"delete_student.php?id={$row['student_id']}\">Delete</a></td>\n";
                                  echo "</tr>\n";
      }                           
      else if($row['teacher_id'] != 0)  //everything is otay panky!
      {
                                  if ($prevkey != $row['teacher_id'])
                        			{
		                                	  $prevkey =  $row['teacher_id'];
		                                      echo "<tr>\n";
		                                      echo "<td style=\"font: bold; color: #FF0000; background: #eeeeee\" colspan=\"10\"><strong>Teacher:&nbsp;{$row['teacher_name']}</strong></td>\n";
		                                      echo "</tr>\n";
		                                      echo "<tr style=\"border: thin solid #eeeeee\">\n";
		                                      echo "<td><strong>Student</strong></td>\n";
		                                      echo "<td><strong>Birthdate</strong></td>\n";
		                                      echo "<td><strong>Age</strong></td>\n";
		                                      echo "<td><strong>Address</strong></td>\n";
		                                      echo "<td><strong>Father's Name</strong></td>\n";
		                                      echo "<td><strong>Mother's Name</strong></td>\n";
		                                      echo "<td><strong>Phone Number</strong></td>\n";
		                                      echo "<td><strong>Parent's Email</strong></td>\n";
		                                      echo "<td><strong>Known Allergies</strong></td>\n";
		                                      echo "</tr>\n";
                        			}
                                  echo "<tr>\n";
                                  echo "<td>{$row['student_fname']}&nbsp;{$row['student_lname']}</td>\n";
                                  echo "<td>{$row['student_bdate']}</td>\n";
                                  echo "<td>{$row['student_age']}</td>\n";
                                  echo "<td>{$row['student_address1']}<br />{$row['student_city']}, {$row['student_state']} {$row['student_zip']}</td>\n";
                                  echo "<td>{$row['student_father']}</td>\n";
                                  echo "<td>{$row['student_mother']}</td>\n";
                                  echo "<td>{$row['student_contact']}</td>\n";
                                  echo "<td><a href=\"mailto:{$row['student_email']}\">{$row['student_email']}</a></td>\n";
                                  echo "<td>{$row['student_allergies']}</td>\n";
                                  echo "<td><a href=\"edit_student.php?id={$row['student_id']}\">Edit</a>&nbsp;<a href=\"delete_student.php?id={$row['student_id']}\">Delete</a></td>\n";
                                  echo "</tr>\n";
      }


}
echo "</table>\n";


//For Students that do not have a Teacher we will print them out here






?>

it is jumping down to the last else if statement and totally bypassing the first two if statements and I cannot understand. I am retrieving all the information from the database, I checked the query in phpmyadmin

You can see the script here:

http://www.sportsrant.com/school/admin/test.php

is it something to do with my query?

Thanks
Mike

[msimonds]

just an FYI: As you can see this is a test script. I tried it another way and it works, but I thought that I could clean up my code a little. the other script that I am messing with has 3 different calls to the database, but it works, just thought it was a little too much:

thought I should post this code to show how this one works

<?php

// Address error handing.
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);


//Setup the datbase connection
include("../include/config.php");
include("../include/opendb.php");
$query = ("
            SELECT teachers.teacher_id, teachers.teacher_name, students.*
            FROM teachers, students
            WHERE teachers.teacher_id = students.teacher_id
            ORDER BY teachers.teacher_name
         ");

$result = mysql_query($query) or die(mysql_error());

$prevkey = "";
// Print out the contents of each row into a table

echo "<table border=\"1\" width=\"100%\">\n";
while($row = mysql_fetch_array($result))
    {

    if ($prevkey != $row['teacher_id'])
        {
            $prevkey =  $row['teacher_id'];
                  echo "<tr>\n";
                  echo "<td style=\"font: bold; color: #FF0000; background: #eeeeee\" colspan=\"10\"><strong>Teacher:&nbsp;{$row['teacher_name']}</strong></td>\n";
                  echo "</tr>\n";
                  echo "<tr style=\"border: thin solid #eeeeee\">\n";
                  echo "<td><strong>Student</strong></td>\n";
                  echo "<td><strong>Birthdate</strong></td>\n";
                  echo "<td><strong>Age</strong></td>\n";
                  echo "<td><strong>Address</strong></td>\n";
                  echo "<td><strong>Father's Name</strong></td>\n";
                  echo "<td><strong>Mother's Name</strong></td>\n";
                  echo "<td><strong>Phone Number</strong></td>\n";
                  echo "<td><strong>Parent's Email</strong></td>\n";
                  echo "<td><strong>Known Allergies</strong></td>\n";
                  echo "</tr>\n";

        }

    echo "<tr>\n";
    echo "<td>{$row['student_fname']}&nbsp;{$row['student_lname']}</td>\n";
    echo "<td>{$row['student_bdate']}</td>\n";
    echo "<td>{$row['student_age']}</td>\n";
    echo "<td>{$row['student_address1']}<br />{$row['student_city']}, {$row['student_state']} {$row['student_zip']}</td>\n";
    echo "<td>{$row['student_father']}</td>\n";
    echo "<td>{$row['student_mother']}</td>\n";
    echo "<td>{$row['student_contact']}</td>\n";
    echo "<td><a href=\"mailto:{$row['student_email']}\">{$row['student_email']}</a></td>\n";
    echo "<td>{$row['student_allergies']}</td>\n";
    echo "<td><a href=\"edit_student.php?id={$row['student_id']}\">Edit</a>&nbsp;<a href=\"delete_student.php?id={$row['student_id']}\">Delete</a></td>\n";
    echo "</tr>\n";



}
echo "</table>\n";


//For Students that do not have a Teacher we will print them out here

$query = "SELECT * FROM `students` WHERE `teacher_id` = 0" ;
$r = mysql_query($query) or die(mysql_error());

echo "<table border=\"1\" width=\"100%\">\n";
echo "<tr>\n";
                  echo "<td style=\"font: bold; color: #FF0000; background: #eeeeee\" colspan=\"10\"><strong>No Teacher Assigned</strong></td>\n";
                  echo "</tr>\n";
                  echo "<tr style=\"border: thin solid #eeeeee\">\n";
                  echo "<td><strong>Student</strong></td>\n";
                  echo "<td><strong>Birthdate</strong></td>\n";
                  echo "<td><strong>Age</strong></td>\n";
                  echo "<td><strong>Address</strong></td>\n";
                  echo "<td><strong>Father's Name</strong></td>\n";
                  echo "<td><strong>Mother's Name</strong></td>\n";
                  echo "<td><strong>Phone Number</strong></td>\n";
                  echo "<td><strong>Parent's Email</strong></td>\n";
                  echo "<td><strong>Known Allergies</strong></td>\n";
                  echo "</tr>\n";


// Retrieve and print every record.
while ($row = mysql_fetch_array ($r))
{
        if ($row['registered'] == 1)
        {

                  echo "<tr>\n";
                  echo "<td>{$row['student_fname']}&nbsp;{$row['student_lname']}</td>\n";
                  echo "<td>{$row['student_bdate']}</td>\n";
                  echo "<td>{$row['student_age']}</td>\n";
                  echo "<td>{$row['student_address1']}<br />{$row['student_city']}, {$row['student_state']} {$row['student_zip']}</td>\n";
                  echo "<td>{$row['student_father']}</td>\n";
                  echo "<td>{$row['student_mother']}</td>\n";
                  echo "<td>{$row['student_contact']}</td>\n";
                  echo "<td><a href=\"mailto:{$row['student_email']}\">{$row['student_email']}</a></td>\n";
                  echo "<td>{$row['student_allergies']}</td>\n";
                  echo "<td><a href=\"edit_student.php?id={$row['student_id']}\">Edit</a>&nbsp;<a href=\"delete_student.php?id={$row['student_id']}\">Delete</a></td>\n";
                  echo "</tr>\n";
        }
 }
                  echo "</table>\n";


$query = "SELECT * FROM `students` WHERE `registered` = 0" ;
$r = mysql_query($query) or die(mysql_error());

echo "<table border=\"1\" width=\"100%\">\n";
echo "<tr>\n";
                  echo "<td style=\"font: bold; color: #FF0000; background: #eeeeee\" colspan=\"10\"><strong>Registered Students from Parents</strong></td>\n";
                  echo "</tr>\n";
                  echo "<tr style=\"border: thin solid #eeeeee\">\n";
                  echo "<td><strong>Student</strong></td>\n";
                  echo "<td><strong>Birthdate</strong></td>\n";
                  echo "<td><strong>Age</strong></td>\n";
                  echo "<td><strong>Address</strong></td>\n";
                  echo "<td><strong>Father's Name</strong></td>\n";
                  echo "<td><strong>Mother's Name</strong></td>\n";
                  echo "<td><strong>Phone Number</strong></td>\n";
                  echo "<td><strong>Parent's Email</strong></td>\n";
                  echo "<td><strong>Known Allergies</strong></td>\n";
                  echo "</tr>\n";


// Retrieve and print every record.
while ($row = mysql_fetch_array ($r))
{


                  echo "<tr>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\">{$row['student_fname']}&nbsp;{$row['student_lname']}</td>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\">{$row['student_bdate']}</td>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\">{$row['student_age']}</td>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\">{$row['student_address1']}<br />{$row['student_city']}, {$row['student_state']} {$row['student_zip']}</td>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\">{$row['student_father']}</td>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\">{$row['student_mother']}</td>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\" >{$row['student_contact']}</td>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\"><a href=\"mailto:{$row['student_email']}\">{$row['student_email']}</a></td>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\">{$row['student_allergies']}</td>\n";
                  echo "<td style=\"font: bold; color: #000000; background: #FFFF00\"><a href=\"edit_student.php?id={$row['student_id']}\">Edit</a>&nbsp;<a href=\"delete_student.php?id={$row['student_id']}\">Delete</a></td>\n";
                  echo "</tr>\n";
 }
                  echo "</table>\n";




?>