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..