PHP MySQL problem

[McMaster]

I have a MySQL query that is having problems. I have a variable called $product_id and I am trying to put it in to the query but it's not showing in the database. This is the query:

 

mysql_query("INSERT INTO inbox VALUES('$from','$from_buyer','<a href=\"read_messages.php?id=$product_id \">link</a>' )");

 

In the database it just shows: <a href=\"read_messages.php?id=

 

 

Any help appreciated here. Thanks guys!

[mattal999]

You forgot a ' after the product id part. It should be:

 

mysql_query("INSERT INTO inbox VALUES('','".$from."','".$from_buyer."','<a href=\"read_messages.php?id=".$product_id."\"')");

[McMaster]

Okay, that never worked. I narrowed the query down a bit. Here is the query here:

 

  mysql_query("INSERT INTO inbox VALUES('','$from','$from_buyer','<a href=\"read_messages.php?id=".$product_id."\"

 

name=\"&lid=//Message Center//Message List//Message Title\" style=\"text-decoration: none;\">Question

 

Answered</a></span><span class=\"small\" style=\"color: rgb(102, 102,

 

102);\"><br>$comment</span>','$comment','$date','0','0','$product_id','1','$from_buyer')");

[Pikachu2000]

Separate your query string from the query statement so you can debug it more easily.

 

$query = "QUERY STRING HERE";
echo $query;
mysql_query($query) or die( mysql_error() );