on unix, but not on windows
Posted: Sat Apr 15, 2006 6:04 am
I have a query that appears to work like I want it to on unix, but not on windows?
On windows, this orders by the topicid desc
IE:
9
8
7
6
5
Where on unix, it orders it by time desc
IE:
8
5
7
6
9
Code: Select all
$active_result = mysql_query("
SELECT
`topicid`,
`forumid`
FROM
`forumentries`
WHERE
`author` = '{$array['id']}'
GROUP BY
`topicid`
ORDER BY
`time`
DESC LIMIT 10
") or die(mysql_error());IE:
9
8
7
6
5
Where on unix, it orders it by time desc
IE:
8
5
7
6
9