HackingTruths Blog

The problem is in the from clause:
“from products_description pd, products d,”
Remove the comma after “products d,”
With the comma, the parser expects another table name whereas this query begins the “where” clause.

If this is being run in PHP, remember that you have to ‘terminate’ the literal string and then concatenate the variables, like so:
‘literal val ‘ .variable. ‘ more literal’
It looks like you’re trying to get PHP variables into the SQL query at Runtime, like {$_GET['id']} for instance.
Another thing to look at, you’re declaring at the end there that you want pd.products_id to equal the literal string ‘p.products_id’
All of this answer is inherently void if there’s something about MySQL that I don’t understand, though it would have to be fundamentally different from most other versions of SQL in order to actually process queries in such a different way.