[tbig]

I'm creating a messgae board, and there are seperate categories, with message boards belonging to each category. I got that far, now the problem is sorting it. All the messages board go to one category, even if its asigned to a different one. All the categories show, just the message board shows in the wrong place.

I used a If/Then statement to help sort.

"If rs1("category") = rs("id") then"
I would think that this would only show the right MB in the right place, but it doesnt.

Category is in the "forum" table and ID is in the "category" table.

Any help please?

[Mikeirv]

I am guessing that the Category field in the Forum table is a varchar and the ID field in the category table is an int.

try this

If clng(rs1("category")) = rs("id") then

this will make the rs1("Category") an integer so it will match

[tbig]

Hey man, that did it thanks allot!