In side a php block I have the following:
$sql2 ="SELECT accountID, account_desc FROM $table_name2 WHERE $type1=accountID";
I can run this query from mySQL and it runs fine however I'm getting a sql syntax error inside the php block. I've tried it with single quotes around the second accountID and same error.
What am I doing wrong?