Append variable to column name during select statement

[eluser]obiron2[/eluser]
Personally, I think your way is quite nice as it definately uses DRY (Don't Repeat Yourself) code.

The only suggestion i would make is to create an array of the field names you want to bring back as well as the $var suffix and I would build the SELECT part of the statement by looping through the array. this way you can pass the $var and $array to a generic query. this saves you from having to store different queries if there are different types of data you require (e.g. Image caption, Alt Text, Copyright, menu link URL)

Obiron