Class Application - Registers

[chwebdesigns]

Hi,

 

I am writing a class application, where students are assigned to a class in a mysql database such as:

 

id                      student_name                      class_assignment

001                    A Student                              1

002                    B Student                              2

003                    C Student                              1

004                    D Student                              1

.... etc.

 

what I want to be able to do is print a table off for each class. I know I could do this individually with an sql such as

 

<?php
$sql = "SELECT * from classes where class_assignment='1'";
?>

 

But what I would like to be able to do is 'report' class 1 register have a page break, then class 2 register etc. in one click - I am unsure at the moment how many classes there are going to be. Is this possible?

 

Hope this makes sense?

 

Many thanks in advance,

Cal

[xyph]

ORDER BY class_assignment

 

might get you started

[chwebdesigns]

Thanks for the quick reply 

 

I am wanting the output to be in a table for example.

 

So if I order by class_assignment that will list all classes in the one table, where each class needs to be in a separate table on the page, so is there a way of splitting the data up like this?

 

Thanks,

Cal 

[Christian F.]

When you're looking at the results, reading down the lines, what tells you that you've come to a new class? If you think about this for a minute, I'm sure you'll see how to solve this in code as well.

[chwebdesigns]

I have been thinking and thinking about it and still I am not getting anywhere. Obviously what will tell me that I have reached a new class by just looking down the list is when the class_assignment number changes

 

 

 

Thanks

[Jessica]

So, write that in code. Here's the pseudo code.

lastID = NULL;

while(looping through results){

  if(lastID != currentID){

      //It's a new class

  }

    //All your other code

  lastID = currentID;

}