I have a web page listing people belonging to different groups, which uses PHP to select information from a MySQL database.

Is there a straightforward way (via a MySQL function or via PHP) to produce a comma separated list
e.g.
Mr X, Ms Y, Mr Z
without there being a comma at the end?

or
Mr X, Ms Y and Mr Z
would be even better?

Many thanks

Have a look at the implode function, which joins an array of strings with another string between each of them.   It does exactly what you want  

I've just checked the syntax ...
      $result = implode(", ",$names);
should do it for you.   To be raelly clever, you could use a preg_replace to replace the last comma with the word "and".

---