Pensacola Fishing Forum banner
1 - 3 of 3 Posts

· Registered
Joined
·
1,190 Posts
The last 20 post are now available on the home page... I am trying to get it to go to the last post but am having problems because of the way the tables have the same filed names and I can not figure it out. The only way around it was to send the page to the bottom when you click on a link there which works OK. On long post, you may need to scroll up a little.



If anyone knows SQL and wants to help me out, here is my statement...



SELECT top 20 * FROM dbo.InstantForum_Topics t1 inner join dbo.InstantForum_Messages m1 on m1.postid = t1.topicid ORDER BY t1.postid DESC



Everything works except it wants to give me the postid from the messages table, not the topics table...
 

· Registered
Joined
·
1,190 Posts
Voodoo Lounge (10/3/2007)Chris, I think you forgot to carry the 3, therefore the data column wont see its prototype in the shadows!!

I have no clue what I just said, just trying to help!!

Great new sight by the way!!
I will have to look at it that way and see if it works... Nope... No luck... There is no 3.... Maybe that's the problem???
 
1 - 3 of 3 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top