gistfile1.txt

<?php
$SQL="SELECT UserID, CONCAT(LastName, ',', Firstname) AS FullName FROM Users ORDER BY LastName, FirstName";

// prepare statement
if ($stmt = $oTechdocs->prepare($SQL)) {
	$stmt->execute() or die ("Could not execute statement");					// execute prepared statement

	$stmt->bind_result($UserID, $FullName);

	while ($r = $stmt->fetch()) {
	echo '<option value="',$UserID,'">',$FullName,'</option>';  
	}
	$stmt->close();		// close statement
}
?>