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.