 |
 |
Andrew, I realize this doesn't answer your question in the slightest, but why not just do this in PHP after your SQL statement? It's going to be a lot easier to wrote the PHP code for displaying properly rather than fiddle with the awkward SQL statement that would replicate it. But then, I'm very lazy. -Ross. Andrew Darby wrote: > Hello, all. Based on the pretty SQL I saw in some recent posts, I > thought I would fall on the mercy of the crowd, and see if anyone could > help . . . > > I'm trying to display (using MySQL/PHP) a list of subject librarians and > their associated subjects, in a neat table. This gets me close: > > SELECT lname, fname, title, tel, email, supersubject FROM supersubs, > staff WHERE supersubs.staff_id = staff.staff_id GROUP BY lname > > except only the first associated subject is delivered. > > The following query gets me all the data I need, but with all the > librarian info duplicated: > > SELECT lname, fname, title, tel, email, supersubject FROM supersubs, > staff WHERE supersubs.staff_id = staff.staff_id GROUP BY lname, > supersubject > > Is there a way, in the SQL, to generate my "mama bear" set: i.e., with > the subjects grouped together like so: > > Smith, Joe | English, History, Italian | 425-5000 | [log in to unmask] > Turner, Ted | Math, Politics, Zoology | 425-5111 | [log in to unmask] > > Or do I have to run another query inside the php loop? (I seem to > remember, from a previous life, that you could do these "queries within > queries" in ColdFusion.) > > Thanks, and I hope this doesn't qualify as a dumb question . . . > > Andrew Darby >