List/Menu

[TheShaftUK]

Hi, I have queried a database and i have the result 'David' In my list/menu field there are :-

David
James
John
Phil

All with the same name values. How do i select 'David' or the result of the querie without duplicating it?

Regards
Julian Chamberlain

[sarahk]

try
$sql = "select distinct firstname from namestable order by firstname";