Henrik

Hi,Did it in SQL and figured it out, thanks again!Henrik

Hi,I have done a search for with checkboxes etc. which works fine but my KEYWORD search does for some reason not work, below is the information from the search form:******<input name='keywords' type='text' class='text' size='50' value='".$_POST["keywords"]."'>// keyword searchingif ($_POST["keywords"]!=""){ $sql .= " AND MATCH (cBio,cPassions,cActive,cSports,cBooks,cMusic,cTelevision,cMovies,cFood,cDrink,cOther) AGAINST ('".mysql_escape_string(strip_tags($_POST["keywords"]))."')";}******The keyword search is producting the following error:Problem with Database Lookup [sELECT * FROM nexus_users WHERE cEMailVerified=cEMailPrivate AND MATCH (cBio,cPassions,cActive,cSports,cBooks,cMusic,cTelevision,cMovies,cFood,cDrink,cOther) AGAINST ('XXX') ORDER BY dLastActivity DESC LIMIT 50]XXX being the keyword(s) entered in the search formIf you have any idea what can be done to make it work, please let me know.Thanks in advance,Henrik

Great!! worked, thanks!Henrik

Hi,Thanks for the quick reply! Yes, I fully understand what you are saying I am not sure how to get it out right, please take a look here:http://solixta.com/nexus/programs.php?acti...m&forumid=2 which is right because I set "$forumID = 2;".if you go to http://solixta.com/nexus/programs.php?acti...m&forumid=3, that one is naturally wrong because I set "$forumID = 2;" I just don´t know how to get it right so I have copied the complete script here,may you can take a look what need to get altered. You can use search for "$forumID = 2;" to get to the place in the script.I appreciate your assistance!Henrik

Hi,I have changed a basic forum script into a program listing script which works fine. My problem is that I like to have a list of members watching the program listed below the program details, they click "join" to be added to the list.My problem:Right now I can only get a list of members watching ALL programs (nForumId` = nForumId) or (nForumId` = 2) it will show all members watching program no. 2 which then is showed below allprograms and is wrong...This is the "nexus_programmembers" table I am using:nForumMemberId nForumId nUserId 1 1 1 2 2 1 3 1 2 4 2 2 This is my code:$data = mysql_query("SELECT nexus_programmembers.nForumId,nexus_programmembers.nUserId, nexus_users.cUsername from nexus_programmembers, nexus_users where nexus_programmembers.nUserId=nexus_users.nUserId and `nForumId` = nForumId")I appreciate any help as I am really stuck here...Thanks in advance!HenrikPS. if you need further info then please let me know