[mythtv] [PATCH] mythweb scheduled recordings list, sql sort fix

[Christopher Maahs]

I noticed a small syntax error in the ORDER BY clause, here is the diff: 

Index: functions.php
===================================================================
RCS file: /var/lib/mythcvs/mythweb/functions.php,v
retrieving revision 1.13
diff -u -r1.13 functions.php
--- functions.php       9 May 2003 16:19:54 -0000       1.13
+++ functions.php       5 Jun 2003 21:03:36 -0000
@@ -302,7 +302,7 @@
 //
 function setupRecordings()
 {
-       $theQuery = "select record.*,channel.channum from record,channel 
where channel.chanid = record.chanid and record.type = 1 order by 
record.startdate and record.starttime asc;";
+       $theQuery = "select record.*,channel.channum from record,channel 
where channel.chanid = record.chanid and record.type = 1 order by 
record.startdate, record.starttime asc;";
        $recordQuery = mysql_query($theQuery) or die("Uh oh, I couldn't 
open the record table");;
        $i = 0;
        while($recordTuple = mysql_fetch_array($recordQuery, MYSQL_ASSOC))


--end


Happy scheduling...

~cj