I made the mistake of naming some of my columns in my table with only numbers.
This is causing problems when trying to update the values in my table. I understand that I need to quote the column name but, I am going in circles.
Here's an example...the value of $template_id = 2
Here's my PHP query:
$update_template_matrix = "UPDATE db12.tblname SET ".$template_id."=1 WHERE id='".$id."'";
How do I quote the $template_id variable (which is a single digit) so that I can use it properly in this query?