> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php