$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());
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
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
$query = mysql_query("SELECT `topicid`,`forumid` FROM `forumentries` WHERE `author` = '$u' GROUP BY `topicid` ORDER BY `time` DESC LIMIT 10") or die(mysql_error());
It's identical, except 'author' in the unix query is a string, where author on the windows query is an integer
[edit] I don't have access to the unix server right now to test it
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.