cvs: qaweb /site_rough editor.php

zak Tue Sep 19 11:52:29 2000 EDT Modified files: /qaweb/site_rough editor.php Log: fixed silly mistake Index: qaweb/site_rough/editor.php diff -u qaweb/site_rough/editor.php:1.4 qaweb/site_rough/editor.php:1.5 --- qaweb/site_rough/editor.php:1.4 Tue Sep 19 11:47:28 2000 +++ qaweb/site_rough/editor.php Tue Sep 19 11:52:28 2000 @@ -59,7 +59,7 @@ $return = '<option>Unapproved Items</option>'; # get unapproved items - $query = "SELECT id, title FROM content WHERE category = '$category' and approved = 'no' ORDER BY stamp DESC"; + $query = "SELECT id, title FROM content WHERE category = '$category' and approved = 'no' ORDER BY time_stamp DESC"; $result = mysql_query ($query); while (list ($id, $title) = @ mysql_fetch_row ($result)) @@ -67,12 +67,10 @@ $return .= '<option></option><option>Approved Items</option>'; # get approved items - $query = "SELECT id, title FROM content WHERE category = '$category' and approved = 'yes' ORDER BY stamp DESC"; + $query = "SELECT id, title FROM content WHERE category = '$category' and approved = 'yes' ORDER BY time_stamp DESC"; $result = mysql_query ($query); while (list ($id, $title) = @ mysql_fetch_row ($result)) $return .= sprintf ('<option value="%s"%s> - %s</option>'."\n", $id, $id == $selected_item ? ' SELECTED':'', htmlentities ($title)); - - print mysql_error (); return '<select name="field[id]">' . $return . '</select>'; }