subject:"\[PHP\-DB\] sql, problem with join and presentation"

Re: [PHP-DB] sql, problem with join and presentation

2004-02-17 Thread Frank Flynn

ECTED]" <[EMAIL PROTECTED]> wrote: > From: mayo [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 15, 2004 11:56 PM > To: php-db > Subject: [PHP-DB] sql, problem with join and presentation > > > Currently I display a list of classes. > Simplified SQL and di

RE: [PHP-DB] sql, problem with join and presentation

2004-02-17 Thread Angelo Zanetti

i think the newer versions of MYSQL allow for subselects and I think that is what you want. see www.mysql.net -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, February 15, 2004 11:56 PM To: php-db Subject: [PHP-DB] sql, problem with join and presentation Currently

[PHP-DB] sql, problem with join and presentation

2004-02-15 Thread mayo

Currently I display a list of classes. 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