Fetching data from foreign table mysql to HTML dropdownlist

Hi,

I am trying to find out how to update my catgor table (which is the second table in my first table(update form)). catgor table has to columns of cat_id (primary key) and catgory(such as good, bad).
When the client update the updateform, the first table has cat_id as a foreign key in it.
My below code works perfectly to read the info (good or bad) from the table however my only concern is that instead of showing good or bad option in my dropdown it shows the completed list with word selected good or selected bad. I would like to have a sticky dropdown for the update form which shows only good, bad or select (in case the client didn’t choose any of them) and then customer do the modification if required. Please advise how I can achieve it?

Thanks,
Saba

<p>
<label for=”cat_id”>Condition:</label>
<select name=”cat_id” id=”cat_id”>
<option value=””>Select Condition</option>
<?php
// get categories
$getCat = ‘SELECT * FROM categor’;
$cats = $conn->query($getCat);
while ($row = $cats->fetch_assoc()) {
$selection = $row[‘cat_id’];
?>
<option value=”<?php echo $row[cat_id’]; ?>”>
<?php
if ($row[‘cat_id’] == $cat_id) {
echo ‘selected’;
}
?>
<?php

echo $row[‘category’]; ?></option>
<?php } ?>

</select>
</p>

Also in #PHP _↴