php获取select输入的值，将其作为表名查询的变量传递给它

Question

I'm trying to get the value of the select box and passing on as a variable to be used as a table name for a query but it came up empty. I couldn't figure out the causes of it. Any chap/gal out there know the issue with the code below?

<select class="form-control" name="properties" type="text" class="form-control" required>
  <?php
    $prop = $_GET['properties'];
    $sql = "SELECT `id`
            FROM '".$prop."' ORDER BY `id` ASC";
    $result = $DB_CON_C->query($sql);
  ?>
</select>