Re: Queries / variables

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.