Jump to content

Query not Working


unkwntech

Recommended Posts

This query:

SELECT productName, productDesc, productPrice FROM products WHERE productDesc LIKE %1%2%3% OR color LIKE %1% OR size LIKE %1% OR color LIKE %2% OR size LIKE %2% OR color LIKE %3% OR size LIKE %3%

is producing this 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 '%1%2%3% OR color LIKE %1% OR size LIKE %1% OR color LIKE %2% OR size LIKE %2% OR' at line 1

 

Any help?

Link to comment
https://forums.phpfreaks.com/topic/116874-query-not-working/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.