如何在select查询中使用多个表？（没有Inner join）

Question

I want to get two tables in one select query without inner join can i do that?

if(isset($_POST['search']))    
{   $name=$_POST['searchtxt'];    

$result = mysql_query("SELECT * FROM `product_tb_men` WHERE `name` LIKE '%".$name."%'");    

}    

this is not the complete code and the second table name is product_tb_women..

Answer 1

You can use UNION this way

if(isset($_POST['search']))    
{
    $name=$_POST['searchtxt'];
    $query = "SELECT * FROM `product_tb_men` WHERE `name` LIKE '%".$name."%'"
                ." UNION "
                ."SELECT * FROM `product_tb_women` WHERE `name` LIKE '%".$name."%'";

    $result = mysql_query($query);
}  

You do need to consider the usage of mysql_* functions and sanitize the value of name to avoid SQL injection