Search found 38 matches
- Mon Nov 05, 2007 5:08 pm
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Thu Oct 25, 2007 11:08 am
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Thu Oct 25, 2007 10:18 am
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Thu Oct 25, 2007 5:07 am
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Thu Oct 25, 2007 4:09 am
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Thu Oct 25, 2007 3:24 am
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Wed Oct 24, 2007 4:54 pm
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Thu Oct 11, 2007 4:43 am
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Sat Oct 06, 2007 3:53 am
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
http://wuggawoo.co.uk/betaForum/?page=f ... =view&id=3
At the moment it orders by the id asc or desc *depending whats put at the end of the query* whereas it should order by the last post.
At the moment it orders by the id asc or desc *depending whats put at the end of the query* whereas it should order by the last post.
- Fri Oct 05, 2007 4:04 pm
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Fri Oct 05, 2007 3:39 am
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Tue Oct 02, 2007 5:09 pm
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Mon Oct 01, 2007 4:20 am
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Sun Sep 30, 2007 4:43 pm
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
- Sun Sep 30, 2007 3:50 pm
- Forum: Databases
- Topic: Ordering by a different table?
- Replies: 27
- Views: 3875
Ordering by a different table?
SELECT t.id FROM `Thread` t JOIN `Post` p ON (p.thread_id = t.id) WHERE t.`forum_id` = $id GROUP BY p.`thread_id` ORDER BY p.`updated` DESC Basically, Im returning a list of threads per forum via a query, however the list of threads should be returned by the post updated time. However it seems this...