Try this :

<?php $submissionRecords = mysql_select('submission', $where); ?>

Name:&nbsp;
<select name="num">
<?php 
    $lastName = array();
    foreach ($submissionRecords as $key => $row) {
        $lastName[$key] = $row['last_name'];
    }
    array_multisort($lastName, SORT_ASC, $submissionRecords); // or SORT_DESC
    foreach ($submissionRecords as $submissionRecord): ?>
<option value = "<?php echo$submissionRecord['num'];?>">#<?php echo $submissionRecord['num']; ?> - <?php echo $submissionRecord['last_name']; ?>, <?php echo $submissionRecord['name']; ?></option>
<?php endforeach ?>
</select>

Thanks!

Djulia

If I can sort the output in the 'sql_select' or the 'foreach' statement that would be great - I need to sort by 'last_name' - any help would be appreciated!

Thanks

nmsinc

       <?php $submissionRecords = mysql_select('submission', $where); ?>
                                                        
       Name:&nbsp;
       <select name="num">
       <?php foreach ($submissionRecords as $submissionRecord): ?>
       <option value = "<?php echo$submissionRecord['num'];?>">#<?php echo $submissionRecord['num']; ?> - <?php echo $submissionRecord['last_name']; ?>, <?php echo $submissionRecord['name']; ?></option>
       <?php endforeach ?>
       </select>