Thanks for the speedy reply! After a bunch more investigating I think there's a problem with my html. I've pasted the SQL queries directly into phpMyAdmin and everything runs just fine there. And I can pull the entire DB in on the first request -- [a href=\"http://stjuliana.org/school/ar/print-old.php\" target=\"_blank\"]http://stjuliana.org/school/ar/print-old.php[/a] -- with the default sorting and grouping, so I know the DB is not corrupt. When I start to play with the sorting and grouping within my html, either in URLs or with form submits, is where it falls down. Any of the grouped/sorted queries below sort/group perfectly within phpMyAdmin, but within my html all I ever get is the default view ($result = SELECT * FROM list ORDER BY name asc), no matter how I try to sort and group I know for a fact it was working at one point in the past; last time I can remember checking it was November of 2005, so I'm really stumped as I haven't edited the bulk of this file in ages. I use Dreamweaver, though, and had some trouble with some editable library/template sections going bad on this entire site so I wonder if Dreamweaver didn't rewrite something out of here that I just can't see. [code] $result = mysql_query("SELECT * FROM list ORDER BY grade asc, name asc"); $sort = "Grouped by grade and then sorted by book name"; if ($view == "name_s") { $result = mysql_query("SELECT * FROM list ORDER BY name asc"); $sort = "Sorted by Book Name"; } elseif ($view == "author_s") { $result = mysql_query("SELECT * FROM list ORDER BY grade asc, author_l asc"); $sort = "Grouped by Grade, Sorted by Author"; } elseif ($view == "author_ns") { $result = mysql_query("SELECT * FROM list ORDER BY author_l asc"); $sort = "Sorted by Author"; } elseif ($view == "level_s") { $result = mysql_query("SELECT * FROM list ORDER BY grade asc, level asc"); $sort = "Grouped by Grade, Sorted by Book Level"; } elseif ($view == "level_ns") { $result = mysql_query("SELECT * FROM list ORDER BY level asc"); $sort = "Sorted by Book Level"; } elseif ($view == "point_s") { $result = mysql_query("SELECT * FROM list ORDER BY grade asc, point asc"); $sort = "Grouped by Grade, Sorted by Point Value"; } elseif ($view == "point_ns") { $result = mysql_query("SELECT * FROM list ORDER BY point asc"); $sort = "Sorted by Point Value"; } [/code] ~Jacy