Find Jobs
Hire Freelancers

Customize SQL query

€8-30 EUR

Ακυρώθηκε
Αναρτήθηκε πάνω από 7 χρόνια πριν

€8-30 EUR

Πληρωμή κατά την παράδοση
I have an SQL Query that loads images from a database. Except in the "type" column are multiple types like jpg, png, pdf. I want the query to only pick the jpg and not show pdf. The query is: $query = 'SELECT b.* FROM #__iproperty AS a ' .'JOIN #__iproperty_images AS b ' .'ON [login to view URL] = [login to view URL] ' .'WHERE [login to view URL] = '.intval($tag->id).' ' .'ORDER BY [login to view URL] ASC '; Can somebody help me with this? I tried to add .'WHERE type = (".jpg",".jpeg",".gif",".png")' but this isn't working.
Ταυτότητα εργασίας: 11186784

Σχετικά με την εργασία

21 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
21 freelancers δίνουν μια μέση προσφορά €18 EUR για αυτή τη δουλειά
Avatar Χρήστη
Hello Good Day I can fix this issue immediately. I can help you on this project. Looking forward to work with you Thanks Rinsad
€15 EUR σε 0 ημέρα
4,9 (1173 αξιολογήσεις)
9,2
9,2
Avatar Χρήστη
Hi, Here's my bid to get it done for you right away. Let me know if you have any questions for further discussion.
€12 EUR σε 1 ημέρα
5,0 (276 αξιολογήσεις)
8,0
8,0
Avatar Χρήστη
hello,i can help you in this issue ready to start now thanks....................................................................................
€32 EUR σε 0 ημέρα
4,8 (195 αξιολογήσεις)
7,4
7,4
Avatar Χρήστη
I can help you in fixing your sql query. I can start right now. Please message me to discuss more. Regards, Mak.
€18 EUR σε 1 ημέρα
5,0 (353 αξιολογήσεις)
6,8
6,8
Avatar Χρήστη
give me phpmyadmin access and 5-10 minutes and then Ill find a solution .............................. ............................... ..............................
€15 EUR σε 1 ημέρα
5,0 (31 αξιολογήσεις)
5,9
5,9
Avatar Χρήστη
Hi, I am interested to work with this query to make it as per your requirement to pick jpg from record table. Please see previous work experience in my profile and please consider my bid. Thanks
€30 EUR σε 1 ημέρα
5,0 (83 αξιολογήσεις)
6,1
6,1
Avatar Χρήστη
I am experienced programmer myself not a bidder, I am interested and offer you my services. let me do it for you. Thanks
€12 EUR σε 1 ημέρα
5,0 (119 αξιολογήσεις)
6,1
6,1
Avatar Χρήστη
Hi! I am a experienced Wordpress, Magento, PHP, CodeIgniter developer. Experienced to write custom library etc. If you offer me the project I can give you guarantee that the project will be executed to the level of your satisfaction. Cheers!
€29 EUR σε 1 ημέρα
4,8 (71 αξιολογήσεις)
6,2
6,2
Avatar Χρήστη
We have gone through your requirements and we can assure you that we can complete your work in a short time period with impressive results. We will give you good output. We got expertise in all kind of skills. We believe in service and we are 24 hours available for you so you can interact with us at any time and ask any query related to your work. Please share your detailed requirement with us. Looking forward to your response. thank you
€23 EUR σε 1 ημέρα
4,7 (128 αξιολογήσεις)
6,3
6,3
Avatar Χρήστη
Dear sir, I am interested in your project"Customize SQL query ". We will customize your SQL query. I am a web developer. I have a group of people who work on your project. We work on website development, mobile application development, website design, app design, UX/UI design few name are here. We have great skills in php, Angular JS,Node JS, Laravel, android, IOS,Graphics design, Coddeigniter, Wordpress, Magento , HTML/CSS, Database query, AJAX, Jquery. I have consistently delivered projects on time and under budget. I brlieve, my skills would be ideal for your project. Me and my team available to chat by email or Skype, and would be happy to set up a convenient time to discuss the project you're moving and some ideas about the safest way to get it into the cloud. Awaiting an affirmative response from your end. Regards, Bhavesh.
€29 EUR σε 0 ημέρα
5,0 (6 αξιολογήσεις)
5,2
5,2
Avatar Χρήστη
Hi, I can check it rightnow. I can start work now. I have excellent skills in mysql,php,js . I am available to discuss rightnow. Thanks
€24 EUR σε 1 ημέρα
5,0 (23 αξιολογήσεις)
4,9
4,9
Avatar Χρήστη
HI, I am having good knowledge in iproperty joomla extension. I can customize the sqL can you let me know some more details or can you provide me the files Thanks Manickavel
€24 EUR σε 0 ημέρα
4,8 (47 αξιολογήσεις)
5,3
5,3
Avatar Χρήστη
Hi, I am Software Engineer. I have skills in Desktop Application Development, Android Development and Databases. I have experience with C/C++, C#, Java, Visual Basic, SQL/MySQL, HTML/CSS and Javascript. I can do your required work. Regards, Naveed Ahmed
€17 EUR σε 1 ημέρα
5,0 (17 αξιολογήσεις)
4,2
4,2
Avatar Χρήστη
Hi There, I can fix it straight away. Thanks
€10 EUR σε 0 ημέρα
4,6 (17 αξιολογήσεις)
4,0
4,0
Avatar Χρήστη
Hi , I could help you out in resolving this issue. This issue could be quickly fixed. Let me know if you want to discuss further on this Regards Barduga
€12 EUR σε 0 ημέρα
5,0 (2 αξιολογήσεις)
2,9
2,9
Avatar Χρήστη
PHP,PDO, Core-php, CakePHP, CodeIgniter, Laravel, Yii, Mysql, HTML, HTML5, CSS, JavaScript, Angular js, jquery, AJax, Joomla, E-Commerce Wordpress, Woo-commerce, Open-cart And BUG FIXING etc. When we work for clients really feel happy because we like to work for clients to give them good services and quality in works. You just message us And feel free to discuss your requirements after that we start your task. We don't keep clients in waiting. Thank you for spending your valuable time for reading proposal. We are looking forward to contribute to your success. You dream it. We will be with you all the way to complete our project as needed.
€15 EUR σε 0 ημέρα
5,0 (7 αξιολογήσεις)
2,7
2,7
Avatar Χρήστη
Dear Client,Hope you doing well. I have gone through your requirement and as per my previous work experience i am ready to start work immediately on your project. yes i am very much expertise with HTML, CMS, Jquery , Java script,C# , Asp.net , Vb , sql , mysql ,Mobile application devlopment
€12 EUR σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Before Award To Any Freelancer Please Discuss With us For Your Project -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- We have gone through the details you have provided. We are Really want to do this project so please give us reply back so that we can discuss more about your requirement and start work on your project ASAP. We are team of experienced Developers , Designers , SEO experts , content writers .. Our team had deployed more then 30+ projects as of now in 4+ countries across the globe. 1) Domain,Hosting 2) website developing 3) website Designing 4) Logo & Template Designing 5) SEO and social media marketing services 6) E-commerce 7) Data Entry 8) Content Writing 9) mobile applications 10) Outsourcing Looking For Hopefully Reply , Hope To Hear You Soon , -Thank You.
€16 EUR σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της NETHERLANDS
Dongen, Netherlands
5,0
12
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Φεβ 3, 2011

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.