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'
I can fix it immediately. You have syntax error that is not compatible with php code. I can start work now
Bu iş için 38 freelancer ortalamada $26 teklif veriyor
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)
Hello, I'm Abu Gosia. I'm interesting your project very well. I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. I m quite well experienced in thes Daha Fazla
Dear Hiring Manager, I’ve carefully gone through your job posting on “ MSSQL database query help ” and I am ready to work with you. I want to thank you for the opportunity to earn your business as your provider of Daha Fazla
Hello, I have checked project requirements and can work on this project. It will be delivered with quality. Thanks.
Hi there, I am sql and php expert. I am sure I can help you to check the issue. Please contact me
INTRODUCTION I can re-write your query using JOINS. I have 4+ years’ experience with database architecture and strategy; exhibiting excellent technical skills, and a keen sense of innovation. I am skilled in data Daha Fazla
Very simple job just let me know few things. Which version of php you are using, is it mysql or mysqli in case you are not able to find that no worries, will figure it out myself. In php 7 there is different ways of Daha Fazla
Hi, dear! If you decide to work with me, I promise I will wonderfully complete your job. I will looking forward to your response.
Sr. Software Professional having 9.0+ years experience. ***************************************************** Technology : Web Application Windows/Desktop Application ************************* Database Lang Daha Fazla
HI, i can solve the issue of Mysql and PHP. kindly send me mysql file so i can fix it Please send me a message so that we can discuss more.
I am working as a senior web developer for 5 years. My key points: -Full time work -Responsive communicate -Clean coding skills I can provide good result to you within your timeframe. When you are Daha Fazla
Hi. I suppose that you have this result because "TB_SKU_LOOKUPS" table is not the same database as other tables. Regards, Andrey.
Thanks for posting job, I have read your description this is possibility to deliverables in proper manner Domaxy Infosoft Pvt. Ltd. deliver quality work with Creativity and incredibility. We are NCR based organization Daha Fazla
Hello Hiring Manager, I have read your job and i’m presenting my proposal for your consideration as a professional website developer and i have great command over HTML5,CSS,CMS and i have already built many responsi Daha Fazla