Shared Hosting
Shared HostingKnowledgebase
Portal Home > Knowledgebase > Articles Database > problem with a postgresql query. Any ideas?
problem with a postgresql query. Any ideas?
 |
 |
 |
Posted by housefire, 12-11-2007, 04:28 PM 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?
Posted by jstanden, 12-11-2007, 05:54 PM You want to "GROUP BY prolaunch ORDER BY prolaunch DESC, pid ASC"
Add to Favourites 
Print this Article
Also Read
