yoursanjay Posted May 11, 2009 Share Posted May 11, 2009 I have 2 fields, Keywords & Type. I have to search from 2 different tables knb_faq & knb_solution as per the keywords & type. Here is my mysql query : $keyword=$_GET['keyword']; $type=$_GET['type']; $srch=mysql_query("select knb_faq.*,knb_solution.* from knb_faq,knb_solution where (knb_faq.solution LIKE '%$keyword%' or knb_faq.keywords LIKE '%$keyword%' or knb_faq.subject LIKE '%$keyword%'and knb_faq.type='$type') or (knb_solution.solution LIKE '%$keyword%' or knb_solution.keywords LIKE '%$keyword%' or knb_faq.solution LIKE '%$keyword%' and knb_solution.type='$type')") or die (mysql_error()); There is no error msg but my problem is that for this query I am not getting result perfectly. The search is occured but it is not searching from both the tables according to Keyword & Type. Is there any wrong in the sql query? If so, Please tell me the right syntax. Link to comment https://forums.phpfreaks.com/topic/157667-search-from-different-tables/ Share on other sites More sharing options...
kickstart Posted May 11, 2009 Share Posted May 11, 2009 Hi First thing I notice is that you are basically joining 2 tables without any join conditions. As such you are first of all bringing back every single combination of records from the 2 tables. Either add a join condition, or select from each table seperatly and UNION the results. All the best Keith Link to comment https://forums.phpfreaks.com/topic/157667-search-from-different-tables/#findComment-831537 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.