when select from mysql remove duplicate names

[tastro]

hi,

also... like said in the title i need a php script that removes duplicate names when reading/select from mysql.

also that it won't output/return/print 2x the same name, for example:

if i have 2x john in my mysql john mclane and john travolta.
but i want only one john to be printed out.

thank you, tastro

[Weirfire]

hi,

also... like said in the title i need a php script that removes duplicate names when reading/select from mysql.

also that it won't output/return/print 2x the same name, for example:

if i have 2x john in my mysql john mclane and john travolta.
but i want only one john to be printed out.

thank you, tastro

I think you're probably looking for

GROUP BY [field name]

where field name is the name of the field that contains names.

[matthewrobertbell]

SELECT DISTINCT(field) ?