dongpu3347 2014-03-11 12:31
浏览 20
已采纳

创建一个完整的mysql搜索查询,搜索多个表

I am trying to search my full website but I'm unsure how to make the query.

    $query = "SELECT * FROM 
game_content,
tech_content,
hint_content
 WHERE 
title LIKE '%".$input."%' 
description LIKE '%".$input."%'";

The tables i want to search are: game_content,tech_content,hint_content & the columns are: title,description each table has these columns

To be honest I'm confused using JOIN i have been getting lots of unexpected results.

  • 写回答

6条回答 默认 最新

  • dousao1175 2014-03-12 13:32
    关注

    After trying out some of your answers i decided to do what Dieter suggested in the comments.

        //set the queries.
    $query[1] = "SELECT * FROM game_content WHERE title LIKE '%".$input."%' OR description LIKE '%".$input."%'";
    $query[2] = "SELECT * FROM hint_content WHERE title LIKE '%".$input."%' OR description LIKE '%".$input."%'";
    $query[3] = "SELECT * FROM tech_content WHERE title LIKE '%".$input."%' OR description LIKE '%".$input."%'";
    
        //loop the queries setting the results
    for ( $i = 1; $i <= 3; $i++ ) {
    
        $result[$i] = mysqli_query( $connection, $query[$i] );
        check_query( $result[$i] );
    
        while( $row = mysqli_fetch_assoc( $result[$i] ) ) {
    
            //display output
        }
    }
    

    It is only a small site so this will suffice.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(5条)

报告相同问题?