[SOLVED] Using a "variable combination" within an SQL statement

[mrherman]

Hello again, friends....

 

I have a function that requires one parameter: an "m" or an "r".

 

If the parameter is an "m", I want to access the db field "mtotcor."

If the parameter is an "r", I want to access the db field "rtotcor."

 

The following throws an error:

 

$sql = "SELECT $param . totcor FROM..."

 

How can I take the passed $param and combine it with "totcor" to make "mtotcor" or "rtotcor" that can be used in the SQL SELECT statement?

 

Thank ya!!

[sader]

$sql = "SELECT $param.totcor FROM..."

 

don't use spaces between .

[mrherman]

Thanks, sader

 

I tried your suggestion, $sql = "SELECT $param.totcor FROM..."

 

This doesn't seem to work....If the $param is an "m", the error is "Unknown column m.totcor..."...

 

Thanks!!

[sader]

$sql = "SELECT $param"."totcor FROM...";

maybe like this :]

[mrherman]

Hi, Sader...

 

Y-E-E-S-S-S-S!!  That is the solution.  Thanks so much for staying on the case! 

 

See ya next time!