if(isset($_POST['search'])){ $mysqli = //tb_insured $command = "SELECT *FROM users WHERE `word`='{$mysqli->real_escape_string($_POST['search'])}' or `def`= '{$mysqli->real_escape_string($_POST['search'])}' "; $select = $mysqli->query($command); if ($select->num_rows > 0) { // output data of each row while($row = $select->fetch_assoc()) { echo "Word: " . $row["word"]. " " . $row["def"]. "
"; } } else { echo "0 results"; } }