SQL statment

Results 1 to 2 of 2

Thread: SQL statment

  1. #1
    Tito Maas Guest

    Default SQL statment

    Iam about to creat a disscussion forum... <BR><BR>I have some problemes with a SQL statment, what i want to do is the following.<BR><BR>My SQL server database consists of 2 tables<BR><BR>One that holds the diffrent forums and descriptions<BR><BR>the other one called Messages contains the messages<BR><BR>MessageID &#039;identifier<BR>ForumID &#039;reference to selected forum<BR>InReplyTo &#039;holds the reference to the thread<BR>PostedBy &#039; person who posted<BR>ETC<BR><BR>I want to be able to count InReplay to in the following statment:<BR><BR>"SELECT * FROM Messages WHERE ForumID = " & ForumID & " ORDER BY Date DESC"<BR><BR>Please help me out!

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL statment

    "SELECT Count(InReplyTo) AS CountofInReply FROM Messages WHERE ForumID = " & ForumID <BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts