Help with select statment

[rocket468]

I would realy apriciate any help.

What I am trying to do is add a completly seperate Item to my bookmark page. So I have taken something that works 100% and just add another sub for entering data "which i have worken" and a sub for viewing saved plans "which i need help on"

I can't get My other set of data thats in the table PLAN_DETAILS" out. when plan_details.plan_id=bookmars.b_planId
Whats throwing me for a loop is the select statments.
I am confused of INNER JOIN and how that works.


Line 366 is where the extra sub starts.
Its all between the comments.
'###################### PHP plans #######################
http://www.professionalhouseplan.com/bookmark.txt
http://www.professionalhouseplan.com/php.mdb

www.professionalhouseplan.com/bookmark.asp?mode=default1
User:test
Pass:test

here is the select stament if you don't want to mess with the txt file

Code: Select all

strSql = "SELECT "& strTablePrefix & "Bookmarks.Bookmark_ID, "& strTablePrefix & "Category.Cat_Name, "& strTablePrefix & "Forum.F_SUBJECT, "& strTablePrefix & "Topics.Topic_ID, "& strTablePrefix & "Topics.T_subject, "& strTablePrefix & "Topics.T_Replies, "& strTablePrefix & "Topics.T_date, "& strTablePrefix & "Topics.T_Last_Post,"& strMemberTablePrefix & "MEMBERS.M_NAME "
    strSQL = strSQL & "," & strTablePrefix & "TOPICS.FORUM_ID, " & strTablePrefix & "TOPICS.CAT_ID, " & strTablePrefix & "TOPICS.T_LAST_POST_AUTHOR "
    strSql = strSql & "FROM ("& strTablePrefix & "Category INNER JOIN "& strTablePrefix & "Forum ON "& strTablePrefix & "Category.Cat_ID = "& strTablePrefix & "Forum.CAT_ID) INNER JOIN ("& strMemberTablePrefix & "Members INNER JOIN ("& strTablePrefix & "Bookmarks INNER JOIN "& strTablePrefix & "Topics ON "& strTablePrefix & "Bookmarks.B_planID = "& strTablePrefix & "Topics.Topic_ID) ON "
    strSql = strSql & strMemberTablePrefix & "Members.Member_id = "& strTablePrefix & "Topics.T_AUTHOR) ON "& strTablePrefix & "Forum.Forum_ID = "& strTablePrefix & "Topics.Forum_id "
    strSql = strSql & "WHERE ("& strTablePrefix & "Bookmarks.B_MemberID=" & getmemberID(strDBNTUserName) & ")"
    if lastDate <> "All" then strsql = strsql & " AND " & strTablePrefix & "TOPICS.T_LAST_POST > '" & lastDate & "'"
    rs.Open strSQL, my_Conn, 3

[rocket468]

as soon as i post this my host goes down. if the links don't work give it afew, my host sucks.

[Rob]

Can you please paste the SQL command AFTER it's been parsed?

[rocket468]

I would i do that?

[Rob]

ok... basically, just before executing your SQL, just response.write the SQL string and post that here instead of the above (I find that a lot easier)