Re: Sorting table columns dynamically on normalized MySQL tables [LONG]
| From: | Chris Boget | Date: | Wed, 20 Apr 2005 12:39:47 +0000 |
| Subject: | Re: Sorting table columns dynamically on normalized MySQL tables [LONG] | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-213493@lists.php.net to get a copy of this message | ||
> The actual SELECT statement is as follows:
> $sqlCourses="SELECT * FROM " . $tbl_courses . " WHERE courseDate >
> '" .
date("Y-m-d") . "' ORDER BY " . $orderBy . " ASC";
> the $orderBy variable is set via $_GET['orderBy'] which is sent by the
> table headers as below:
I'm curious why you aren't joining the other tables? That will
solve all your woes...
thnx,
Chris