Need a simple query to count total blocked users..

$10-30 USD

Completed

Posted

almost 6 years ago

$10-30 USD

Paid on delivery

************* 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

Project ID: 17156338

About the project

13 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

4.9

(2 reviews)

1.0

13 freelancers are bidding on average $17 USD for this job

@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 in 1 day

4.9

(32 reviews)

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 in 0 day

4.9

(8 reviews)

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 in 1 day

5.0

(17 reviews)

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 in 1 day

5.0

(8 reviews)

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 in 1 day

0.0

(0 reviews)

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 in 0 day