Multiple tables row sort for display,help

ravinder

I have several tables holding category info for levels, locations, subjects linked by tables tlevel, tlocation, tsubject and a tutors table linked by foreign keys.

I am using query in the following concept (not actual code) SELECT Name, Level, Subject, Location, Subject FROM levels,tlevel,locations,tlocation,subjects, tsubject WHERE...cond(levelsID)=cond(tlevelID) AND ...cond(subjectID)=cond(tsubjectID)...etc

I have rows returned with several duplicated names, levels,subject and locations.
Eg. tutor AAA
can teach Level1, Level2...
can teachSubject1,Subject2...
at Location1, Location2, Location3 and Location4

current display :
AAA,Level1,Subject1,Location1
AAA,Level2,Subject1,Location1
AAA.Level1,Subject2,Location1

I need to display after fetching rows in PHP

AAA
Levels: Level1, Level2
Subject:Location1, Location2....

Thus, comparing the return cols for duplicates and print once.

Grateful for your time in considering the above. Thks!

OhLordy

ORDER BY Name, Leve, Subject, Location at the very end of your query will put your results in the form

AAA,Level1,Subject1,Location1
AAA.Level1,Subject2,Location1
AAA,Level2,Subject1,Location1

HTH
Rob

Sxooter

What you're really probably looking for is code to loop over those categories and display it.

You'll need to do something like:
(Comments added)

# Next line is ultra paranoid to prevent injection in reg globals on environments.
# It basically unsets oldcat, and it's bad style to unset somthing if it isn't set and
# expect the parser to just figure it out.
if (isset($oldcat1)) unset($oldcat1);
# the fetch_array for your database will report false when it can't get a new row
while ($row = fetch_array()){
    $firstcat = $row['firstcat'];
# See if $oldcat got set.  If this is our first time through, it won't be.
    if (!isset($oldcat1)) $oldcat1='';
# If they aren't the same, then the header changed and we need to
# print it out. Plus set it.
   if ($oldcat1!=$firstcat){
        print_header($firstcat);
        $oldcat1 = $firstcat;
    } else {
        print_dummy_first_field();
    }
        //code like the stuff aboe for the next column here...

}

ravinder

Thks Sxooter.

Sounds like what I am lookin for.

Will try it out.

Have a nice day!
🙂