PHP pdo inside a html drop down

PHP Code


<?php
                                                
                                                
$query9 = $db->prepare('SELECT * FROM categories WHERE takeawayid= ? ');
 $query9->execute(array($_SESSION['id']));
    // alternatively you could use PDOStatement::fetchAll() and get rid of the loop
    // this is dependent upon the design of your app
    foreach ($query9 as $row9) {
                                                
                                                ?>
 <select name="country" class="form-control form-select form-select-lg select2" data-bs-placeholder="Select Country">
 <option value="<?php echo $row9['cat_id']; ?>"name = "topic_cat"id="topic_cat" ><?php echo $row9['cat_name']; ?></option>
    </select>                                        
<?php } ?>
                                              
                                      
                                    </div>
                                              
                                              
                                        <input type="submit"   class="btn btn-success my-1">
                                              
                                      </form>