Need a simple query to count total blocked users..

$10-30 USD

Ολοκληρώθηκε

Αναρτήθηκε

περίπου 6 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

************* No c/panel logins given don't ask.. Project for files only.. *************** Don't bid if you can't abide by my project... I will only pay $10.00 milestone at end of completion. I will send file or files so you can edit then send back, i upload for tests... All i need a a query to pull the total count number for blocked column or meaning (blocked users).. Right now its showing the count number FROM probid_admin_stats or $data in screenshot that i do-NOT want.. I need for it to pull data of the total count blocked users i have blocked..From: " blocked column FROM " . DB_PREFIX . "users WHERE blocked='2'"........ The work is on Admin panel so i will do the testing, its not user side viewable..

HTML

PHP

SQL

Ταυτότητα εργασίας: 17156338

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

13 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 6 χρόνια πριν

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

Διεύθυνση Email

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

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@nelsonthesantos

Hello! I want to fix this issue for you but looking at the code it appears that it may already be fixed? On your line 49 it says count_rows from users where blocked=2, is that not what you want? And just so you know, I have a lot of experience with MySQL and PHP so this should be a very simple fix if that is not what you wanted.

$10 USD σε 1 ημέρα

4,9

(2 αξιολογήσεις)

1,0

13 freelancers δίνουν μια μέση προσφορά $17 USD για αυτή τη δουλειά

@dilshadbukhari

I have more than 4 years experience in PHP programming and well versed in android and in open-sources / Framework like Codeigniter , OpenCart, Wordpress and other Web solutions . My strengths are web development, PHP, ajax, CSS, HTML , Web Service etc. I have spent a significant part of my career also working as an HTML,CSS,BOOTSTRAP,JAVASCRIPT,PHP,AJAX, JQUERY, MYSQL, and Codeigniter etc... Developer. If hired by you I will deliver my work to the highest quality. I am ready to be hired by you.

$30 USD σε 1 ημέρα

4,9

(32 αξιολογήσεις)

4,9

@vb890306

Hi, I am a SQL query expert. I need to know about your db and table structure. No problem. I will complete it within 1 hour if you choose me. Regards.

$15 USD σε 0 ημέρα

4,9

(8 αξιολογήσεις)

3,6

@AndreiAngelica

Hello, I can help you very easy. I am an expert developer in PHP coding language. I can make the query to display all the users blocked. Contact me for more informations!

$10 USD σε 1 ημέρα

5,0

(17 αξιολογήσεις)

3,7

@develsu

I understand that you want a standalone query for counting the blocked users instead to reading the number from query that fetches all the results.

$12 USD σε 1 ημέρα

5,0

(8 αξιολογήσεις)

2,2

@PVIVEK33

Well i have basically worked on many banking projects wherin i had faced or made query to extract the results as quickly as possible. As we are aware based on the simple and identifying condition you can get your results quickly otherwise sometimes due to the huge records in the table , fetching of the data takes much time. i have worked on IBM Db2 , Oracle, PlSQL Developer tools for my data migration projects and even for cash management application. I am a database tester having 5.9 years of experience. i Can help you to provide a simple query with condition so that easily you can check and obtain the results and even the same query can be used for others tables as well just you need to change the table name.

$25 USD σε 1 ημέρα

0,0

(0 αξιολογήσεις)

0,0

@lobeejack

Hi, Let me do this for you. I DON'T need cpanel logins. But I need the column names/fields in the users table to see the structure. SELECT * FROM `probid_admin_stats`, I see it looks like you have used VIEW `probid_admin_stats`.

$10 USD σε 0 ημέρα