<?php
// Include your database connection code or configuration here
include('../config/dbcon.php');

// Prepare and execute the SQL query to fetch clients
$clientQuery = "SELECT * FROM clients ORDER BY clientName";
$result = $conn->query($clientQuery);

$options = "";
while ($row = $result->fetch_assoc()) {
    $options .= "<option value='" . $row['clientID'] . "'>" . $row['clientName'] . "</option>";
}

// Close the database connection
$conn->close();

// Return the HTML options
echo $options;
?>