The query below is used to select products from a database based on the barcode, or UPC. When I execute this query is SMSS, it works fine and returns 1 result. When I execute on the website using PHP, it returns nothing. I don't see errors and don't have the skills to take this further. I want to know why the query does not work as well as the recommended path to make it work. This is a one time job, but other work will arise in the future.
FROM TB_SKU_LOOKUPS l,
[celerant].[dbo].[TB_SKUS] skus, [celerant].[dbo].[TB_STYLES] styles
where skus.STYLE_ID=styles.STYLE_ID and l.SKU_ID = skus.SKU_ID
and [login to view URL] like '4643'
38 pekerja bebas membida secara purata $26 untuk pekerjaan ini
Hello, I can fix your database issue error as per your given brief on project post. Let me know when you available to discuss more in detailed. Regards Rina
Try and [login to view URL] like ''4643'' or and [login to view URL] like '''4643''' (try with double or triple quotations instead of single in your php code query)