editprojectvariable.php

<?php

$sql = "SELECT id, forename, surname
        FROM character_information
        WHERE project_name='$project_name'
        AND username='$usernamevariable'";

$characters = $conn->query($sql);

while ($character = $characters->fetch_assoc()) {
  $id = $character['id'];
  $name = $character['forename'] . ' ' . $character['surname'];
  echo "<option value=\"$id\">$name</option>";
}

?>