Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

[Simon Todd]

I have the following code

$subcat=$_POST['subcat'];
$results=array();
$result=mysql_query("SELECT * FROM `subcategory` where `subcategory`=$subcat") or die(mysql_error());
while($a_row = mysql_fetch_array($result, MYSQL_ASSOC)) array_push($results, $a_row);

I have verfified that $subcat is presenting a correct value by echoing it onto the screen, but this is where the problem is, for example, the echo reports it returns this value from the database which is correct:

'145 1.9JTD 105 BHP' or another Example would be "A4,1.9TDI,130 BHP"

But when the mySQL query is ran the following message is displayed

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1.9JTD 105 BHP' at line 1

or the other example
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1.9TDI,130 BHP' at line 1

For some reason it is removing the first section of the value, and then the database produces a returned value of 0

Any ideas why? I am using MySQL 5