table name as a variable???

[bailo81]

i keep getting an error from this:

$db_sql_query ="INSERT INTO $table

(item_title item_type,
item_description)

			  				VALUES  (\"$title\",					               \"$type\", 
	               \"$description\")";

it works fine when i replace $table with the actual table name, but not when the table name is in the variable, can anyone help?

[acrabadabra]

Should be working. Just make sure you use the double quote and not the single quote. Try to debug for yourself and put a echo after the $db_sql_query = ... etc. So you know what is happening.

You could also try to write it down as:

$db_sql_query ="INSERT INTO " . $table .  "....

Good luck!

[bailo81]

the problem was so stupid i want to hit myself with a mallet! Forgot to put the include code for the php file my database connection details are in.

What an idiot I am!!! 🙁