i am trying to write a search script. I have 3 tables where i need info from. 2 to be searched. I have tried various things but what i try usualy locks up the browser. this is what i have to convert to FULL TEXT SEARCH [code] "SELECT p.fp_id, t.ft_title, t.ft_id, t.ft_creationdate, t.ft_firstpostername , t.ft_firstposterid, t.ft_postcount , s.fs_id, s.fs_title FROM db_forum_posts p, db_forum_topics t, db_forum_sections s WHERE 1 AND (p.fp_text LIKE '".($sqstr)."' OR t.ft_title LIKE '".($sqstr)."') $atleastq $dspresultsp AND p.fp_topicid=t.ft_id AND p.fp_sectionid=s.fs_id GROUP BY t.ft_id"); [/code] This is what i tried at first: [code] SELECT p.fp_id, t.ft_title, t.ft_id, t.ft_creationdate, t.ft_firstpostername , t.ft_firstposterid, t.ft_postcount , s.fs_id, s.fs_title FROM sed_forum_posts AS p, sed_forum_topics AS t, sed_forum_sections AS s WHERE p.fp_topicid=t.ft_id AND p.fp_sectionid= s.fs_id AND MATCH (p.fp_text) AGAINST ('admin pro') OR MATCH (t.ft_title) AGAINST ('admin pro') [/code] but the browser locks up. i also tried [code] SELECT p.fp_id, t.ft_title, t.ft_id, t.ft_creationdate, t.ft_firstpostername , t.ft_firstposterid, t.ft_postcount , s.fs_id, s.fs_title FROM sed_forum_posts AS p, sed_forum_topics AS t, sed_forum_sections AS s WHERE p.fp_topicid=t.ft_id AND p.fp_sectionid= s.fs_id AND MATCH (p.fp_text, t.ft_title) AGAINST ('admin pro') [/code] However i get a SQL error for MATCH. #1210 - Incorrect arguments to MATCH how would i correctly structure this so i can search for text in one table and title text in another table at once and return them and their row? how also would i do it and order by score/relevance. Would you like to see the tables?