I am making a forum (I have made many before), and in my forums I have "sticky" threads and non "sticky" threads. The "sticky" threads are the important ones and they are at the top of the forum on the first page. In order for a thread to be sticky it has to have a 1 in the column sticky, otherwise it will be a 0 which is a nonsticky thread. I also have a column called replytime which is the time of the newest reply. To make my forum I have the first while loop which selects the sticky threads and the second while loop is the normal threads. Is it possible to have a SQL query where it orders the threads by the two columns of sticky and replytime, so first it displays the sticky threads and then the non sticky ones, yet they are all in order, by the newest replyed threads at the top? If this is possible how would I go about doing it?
