[thelist] combining mutiple fields in db

Les Lytollis les.lytollis at morse.com
Thu Dec 5 07:43:01 CST 2002


Hi All,

I need to produce a comma delimited text file in the format Artist,
Description, Price. My existing db is in the format Artist, Title, Format,
Grade, Comments, Cat No., Price.

How would I merge the Title, Format, Grade, Comments, Cat No. into a
Description field? Can I do this in SQL or would I need to do it
programatically.

I am using PHP / mySQL.

TIA
Lez




More information about the thelist mailing list