Simplified SQL and display below:
SELECT *
FROM classes
WHERE
classCategory='$Category' AND
classDeleted=0
ORDER BY $order $reorder
The presentation is:
+------------------+----------+------------+
| CLASS TITLE | LOCATION | CLASS CODE |
+------------------+----------+------------+
| CLASS DESCRIPTION <br/><br/> |
| CLASS INSTRUCTOR <br/><br/> |
| CLASS TIME |
+------------------------------------------+
Now, things are getting a little more complicated. Each class is going to
have sections. So the display will be:
CLASS TITLE
CLASS DESCRIPTION
CLASS CODE : CLASS SECTION .. LOCATION .. CLASS TIME .. INSTRUCTOR
example (simplified)
+---------------------------------------------+
| INTRO TO AAA |
+---------------------------------------------+
| This is a really interesting .... |
| |
+---------+-----+------------+----------------+
|HT-111:A | NYC | 12:00-4:00 | Albert Alkin |
|HT-111:B | JC | 2:00-6:00 | Bob Bailey |
|HT-111:C | BX | 4:00-8:00 | Chris Cawley |
+---------+-----+------------+----------------+
I'm having a really hard time coming up with the sql for this.
tables below
CLASSES
classID
classDescription
classTexts
classCost
classDeleted
CLASSCODES
classCodeID
classID
classCodeSection
classDate
classTime
classLocation
classInstructor
I'm going nuts trying to get this. (using mysql)
thx for any clues
Gil
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
