What does it mean by: $table_key = $multi_lang->TableKey(COUNTRY_SPR_TABLE);

[reddymade]

Please help, I am new to php. I need to add a small new functionality to the existing file.

What is $table_key
How to find the field name referencing to .$field_name.

////  country select
$table_key = $multi_lang->TableKey(COUNTRY_SPR_TABLE); 

$strSQL = "select distinct a.id, b.".$field_name." as name from ".COUNTRY_SPR_TABLE." a left join ".REFERENCE_LANG_TABLE." b on b.table_key='".$table_key."' and b.id_reference=a.id order by name ";

I am trying to add a new drop down select list box: to show all states for a country.

Please help if you can, i am also attaching the php file with .tpl file.

Thank you very much.

[unreal128]

Lets first break down what the statement means.

$table_key = $multi_lang->TableKey(COUNTRY_SPR_TABLE);

If you are unfamiliar with object oriented programming, then this may be harder to understand. The $multi_lang object is created by a "new" declaration, like "$multi_lang = new dontKnowClass;". The class it references (which I don't know from the snippet given) calls a function named TableKey which performs a SQL query to the database. To find out exactly what $table_key is, we need to see what the TableKey function does. First find out which class $multi_lang is created from and then open that class file. Inside that class file, you will find the TableKey function. This function will tell us what it does to the data.

[reddymade]

Excellent Thank you very much for the help. Now i should be able to find the class file, in the project folder.