http://forum.lowyat.net/ Wed, 10 Jun 2026 16:09:35 +0800 FeedCreator 1.7.2 http://forum.lowyat.net/topic/1863917 Hi there, I had done a quick search and hardly find topic on how to setup a forum.<br />I am a totally newbie and have &#39;0&#39; knowledge on web hosting, but I noe IT <!--emo&:)--><img src='http://static.lowyat.net/style_emoticons/default/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /><!--endemo--> <br /> <!--emo&:help:--><img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /><!--endemo--> <br /><br />Let say im choosing serverfreak to host my forum, do they provide the forum hosting tools, as in interface and easy setup forum?<br />Whats the different between free forum hosting compared to the paid one? <br />Anyone can provide me the guide for this?<br /><br /> HenDa Content Creators, Blogmasters &amp; Webmasters Wed, 04 May 2011 21:15:40 +0800 http://forum.lowyat.net/topic/1446347 Need some help on SQL Query @@<br />Currently i have this query, which work fine <br /><br />SELECT T.Tour_ID, TD.Accommodation_ID,COUNT(S.student_id)AS student, COUNT(TT.Teacher_id) AS teacher,<b> COUNT(S.student_id) + Count(TT.Teacher_iD)+ 2 AS total </b> , A.No_Of_Beds <br />FROM Student S, Accommodation A, Tour_Destination TD, Tour_Teacher TT, Tour T<br />WHERE S.tour_ID = T.tour_ID AND TT.Tour_ID = T.Tour_ID AND TD.Tour_ID = T.Tour_ID AND TD.Accommodation_ID = A.Accommodation_ID<br />GROUP BY A.No_Of_Beds,T.Tour_ID,TD.Accommodation_ID<br /><br />Where The Column showed would be<br /><br /><b>Tour ID | Accommodation ID | Student | Teacher | Total | No of Bed</b><br /><br /><br />How can I get the value in Total&lt;--- from <b>COUNT(S.student_id) + Count(TT.Teacher_iD) + 2</b><br />so that i can compare it with No. of Bed<br /><br />FYI, I am working on trigger so that if no. of bed &lt; total, the transaction would roll back HenDa Codemasters Fri, 04 Jun 2010 16:20:46 +0800