$MembersType in an sql string as table name

[brown2005]

Hi,

 

I was just wondering how to write the code below so that where $MembersType is in the sql string can select different tables.

 

thanks

 

function CountMembers($MembersType)
{
  	
$CountMembers_sql = "

SELECT COUNT(*) AS CountMembers_Number 
FROM $MembersType_members  
LIMIT 1;

";


}

[PHP_PhREEEk]

Different tables, or different fields??

 

PhREEEk