PHP Forum Order

[Nick]

I started making a forum system a couple weeks before I joined this forum, but I haven't got to work on it for awhile. I started back up yesterday. I am making the category/board system. I just made the category system work with an admin feature to create a new category. I just need some code that will decide how to order them. I am a little worn out and I can't really think, so any ideas?

[Cam]

Sounds good! I will post ideas later, got to run Sounds good though, good start ;D

[xcessive]

...lol


SELECT * FROM whatever ORDER BY DESC

[russellr]

Yes ^ that could use the Id or just make an order line all depends really....

[Nick]

Yeah, I have that part. What I meant, is how to insert the order number. Like in Pb where it asks where you want to place it (above/below) a certain category.

[russellr]

Create another column with your board and add it to the query....

[Nick]

I think I know what to do now, but itll be a long function

[russellr]

Could just be
SELECT * FROM table_name ORDER BY order_col DESC

thats not too long

[Nick]

I meant inserting the order and making sure none are the same number

[russellr]

Well it would not matter if they are the same number really as you could set it to order by a-b in title if the same and then select order number in admin panel :/

But yes it slightly longer function but it does the job and thats all the matters really.