html - multiple WHERE entries in one php query from database?

Question

I am trying to display entries in one table from my 'shop' database WHERE fragrance is lager & pilsner.

So far I have only able to get either-or to be displayed:

$query2 = "SELECT * from shop WHERE fragrance='Lager'";

//generate SQL query
$result1=$dbh->prepare($query1);

//execute query
$result1->execute();

echo '<table id="tab1">';
 while($row=$result1->fetch()){
echo '<tr>';
echo '<td>'.$row['name'].'</td>';
echo '<td>'.$row['type'].'</td>';
echo '<td>'.$row['fragrance'].'</td>';
echo '<td>'.$row['price'].'</td>';
echo '</tr>';
}
echo '</table>';

How do I search for both in one query? any help would be amazing!

question from:https://stackoverflow.com/questions/65645538/multiple-where-entries-in-one-php-query-from-database

Answer 1

You need an OR operator

"SELECT * from shop WHERE fragrance='Lager' OR fragrance='Pilsner'