John Davidson

Message:

I'm trying to insert values in the contents table. It works fine if I do not have a PHP variable inside VALUES. When I put the variable $type inside VALUES then this doesn't work. What am I doing wrong?

$type = 'testing';

mysql_query("INSERT INTO contents (type, reporter, description) 

     VALUES($type, 'john', 'whatever')");

---

My Answer:
You need to properly concatenate the PHP variable inside the MySQL statement. Here is the corrected code:

php
$type = 'testing';
mysql_query("INSERT INTO contents (type, reporter, description) VALUES('$type', 'john', 'whatever')");


By adding single quotes around the `$type` variable inside the `VALUES` section of the MySQL query, you are telling MySQL that it is a string value. This should now work correctly.