Posted by Chris Boget on 04/20/05 15:39

> 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

• Next in forum: Re: [PHP] Sorting table columns dynamically on normalized MySQL tables
• Prev in forum: Re: [PHP] Sorting table columns dynamically on normalized MySQL tables [LONG]
• Thread view: Re: [PHP] Sorting table columns dynamically on normalized MySQL tables [LONG]

[Reply to this message]