[SOLVED] displaying topics in order

[runnerjp]

currently i try and order my posts like so

 

$getthreads="Select * from forumtutorial_posts where parentid='0' and forum = '$forum' ORDER BY important ASC, lastrepliedto DESC $max";

 

what i have done is where i want a topic to be sticky (like on here but mines called important) that its 1st in the orfer of topics then under it follows the lastreplies to the newest on top..

 

$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;

 

but the thing is it puts it in any random order :S

[ober]

What is in the field important?  1/0?  We need a little more information.

[runnerjp]

the field important is indeed 1/0  ... i fixed it tho while waiting... was sum sql trouble with setting the default to 0 and i needed it to be 2