Tamamlanmış

MSSQL database query help

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.

SELECT style

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'

Beceriler: Veri Tabanı Yönetimi, Veritabanı Programlama, PHP, SQL

Daha fazlasını gör: easy oop php database query, dolphin database query error, google maps mssql database, sql server, complex sql query examples, sql query examples, sql queries, sql tutorial, how to write sql queries, sql commands, sql server management studio, php, mysql, html, software architecture, javascript, codeigniter, angular.js, getafreelancer message sql query help needed, show results database query panel java

İşveren Hakkında:
( 5 değerlendirme ) Portland, United States

Proje NO: #17623269

Seçilen:

sujasheena

I can fix it immediately. You have syntax error that is not compatible with php code. I can start work now

%selectedBids___i_period_sub_7% gün içinde 25%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(22 Değerlendirme)
4.0

Bu iş için 38 freelancer ortalamada $26 teklif veriyor

AltiuseCreaton

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(79 Değerlendirme)
7.2
Neno585

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)

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(32 Değerlendirme)
7.4
in %bids___i_period_sub_35% gün içinde24%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(182 Değerlendirme)
7.1
abugosia

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(129 Değerlendirme)
6.6
royalwebraisers

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(85 Değerlendirme)
6.1
gursukh

I can help you now.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(98 Değerlendirme)
6.1
digidreamstech

Hello, I have checked project requirements and can work on this project. It will be delivered with quality. Thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(46 Değerlendirme)
5.9
manhpham

Hi there, I am sql and php expert. I am sure I can help you to check the issue. Please contact me

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(55 Değerlendirme)
5.7
fanninson45

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(24 Değerlendirme)
5.9
Rashmiagg

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(61 Değerlendirme)
5.6
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(58 Değerlendirme)
5.4
alexdanilovua

Hi, dear! If you decide to work with me, I promise I will wonderfully complete your job. I will looking forward to your response.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(19 Değerlendirme)
4.9
khp31

Sr. Software Professional having 9.0+ years experience. ***************************************************** Technology : Web Application Windows/Desktop Application ************************* Database Lang Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(17 Değerlendirme)
4.3
patidarrahul5233

I have 6+ years of experience in php/wordpress/codeignitor/javascript/html/css and will deliver your requirement on time and in an efficient [login to view URL] Share Further [login to view URL] To Start.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)
4.2
in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
3.9
steffi1985

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(10 Değerlendirme)
3.9
JohnNetworking

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
3.6
doxan

Hi. I suppose that you have this result because "TB_SKU_LOOKUPS" table is not the same database as other tables. Regards, Andrey.

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
3.2
omsir111

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
2.9
twinklekaur

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
2.9