I have a very dynamic scenario that requires met to store queries as a string in the database, the problem I have is that the following have resulted in a syntax error where the variables are creating a MySQL error with the error showing the variable name and not the value. The SQL is pulled from the database then set up like so:
I have tried the following all resulting in the same issue, and I am stumped:
FROM '.$database_1_old.'.'.$table1.' as dsp
FROM '".$database_1_old."'.'".$table1."' as dsp
FROM '" . $database_1_old . "'.'" . $table1 . "'
I have also tried using the eval function thinking that might get around the errors and use the variables as intended, but I get an t string error in the first few characters in my column list.
I have used variables in queries before, but not in this manner where the query is a row from a database.
What am I missing?