```
    <!DOCTYPE html>

        <head>  
        </head>
        <body>
        <?php   
            if (isset($_GET['ProductGroupNo'])) {
        // Connect to the MySQL database  
        dbconnect(); 
        $id = preg_replace('#[^0-9]#i', '', $_GET['ProductGroupNo']); 
        // To check to see if this ID exists, if yes then get the product 
        // details, if no then exit this script and give message why
        $stmt = $conn->prepare("SELECT * FROM Product_Group WHERE ProductGroupNo=:id");
        $stmt->bindParam('id',$id);
        $stmt->execute();
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        if($row) {
                $Name = $row["Name"];
                $Start_Cost = $row["Start_Cost"];
                $Description = $row["Description"];

            ?>      
            <!-- Main Content -->  
    <div id="templatemo_body_wrapper">
    <div id="templatemo_wrapper">

        <div id="templatemo_main">
            <div id="content" class="float_r">
                <h4><?php echo $row['Name']; ?></h4>

                <h5>Product Description</h5>
            <p><?php echo $row['Description']; ?>       </p>    
                    <div class="cleaner h50"></div> 
                <div class="content_half float_r">
                 <table>
                        <tr>
                            <td width="160">Price:</td>
                            <td><?php echo $row['Start_Cost']; ?></td>

 </tr>
                    <tr>
                        </tr>
                    <tr>

```

It should show a dropdown option based on the id from the `$id` on top

```
    <td>Length(inches):</td>
                        <td>
                        <select name="length" id="length">
                        <?php
                        dbconnect();
                        $stmt = $conn->prepare("
                        SELECT Table2.Name 
                        FROM Table2 
                        LEFT JOIN Table1 ON Table1.vid = Table2.vid 
                        WHERE Table1.id = '$id'");
                        $stmt->execute();
                            $i = 0;
                            foreach( $stmt->fetchAll(PDO::FETCH_ASSOC) as $row )
                            {
                                if ($i == 0)
                                {
                                    echo '<option',fillSelect('Name',$row['vid'],'',true),' value="'.$row['vid'].'">'.$row['Name'].'</option>';
                                }
                                else
                                {
                                    echo '<option',fillSelect('Name',$row['vid']),' value="'.$row['vid'].'">'.$row['Name'].'</option>';
                                }
                                $i++;
                            }
                            ?>
                        </select>

------------------------------------------------------------------------------------------
    **Table 1

         id      Vid         coke   Tea   
          1.     1           11      33
          2.     2           32      44

    Table 2

         vid        id                Name      snacks
          1.         1                coke      chocolate           
          2.         2                tea       biscuit**

Is they a way to `SELECT` everything from the Name column if the $id matches the id  from the table 1

```