array of containing each unique value

[johnmacd]

select code,first_name,last_name from table name;

[johnj]

please read about the built-in function called mysql_fetch_array
http://php.net/manual/en/function.mysql-fetch-array.php