rendered paste body<?php
$query = "SELECT distinct name FROM list order by name";
$result = mysql_query($query);
print "<SELECT name=attorney>";
while ($line = mysql_fetch_array($result)) {
$fullname = fixName($value);
print "<OPTION value=''>$fullname</OPTION>";
}
function fixName($nm) {
$nm = explode(" ", $nm);
$count = count($nm)-1;
if ($nm[$count] == " ") {
$count = $count-1;
}
for ($i=0; $i < $count; $i++ ) {
$finalName = $finalName . $nm[$i];
if ($i != $count - 1) {
$finalName = $finalName . " ";
}
}
$finalName = $nm[$count] . ", " . $finalName;
return $finalName;
}
?>