Im trying to fix someone elses code in posgresql and having some problems.

The query is:

$query = "SELECT pid FROM pcomments WHERE date > $sdate AND date < $edate GROUP BY prolaunch DESC,pid";


however that query is giving the following error:

Warning: pg_query(): Query failed: ERROR: syntax error at or near "DESC" at character 90 in /home/path/file.php on line 48

Anyone have any ideas?

You want to "GROUP BY prolaunch ORDER BY prolaunch DESC, pid ASC"