Ron Piggott wrote: > What is the correct syntax for this? > > $description = > mysql_result($image_result,0,"photo_gallery_index.description_{$language}"); > > I am offering a web page in multiple languages. $language is what > language the user is requesting. There is a matching column in the > table for each language. > > For example I may be trying to get the value of description_french > > I am trying to use the variable instead of having several mysql_result > lines > > Ron mysql_result($image_result,0,"photo_gallery_index.description_$language"); Should work, I think. However, it seems you are returning all the language fields for each query but only using one. Why not just retrieve the specified language instead, based on the content of $language? Cheers -- David Robley Circular Definition: see Definition, Circular. Today is Sweetmorn, the 49th day of The Aftermath in the YOLD 3174. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php