Need a simple query to count total blocked users..

$10-30 USD

Terminado

Publicado

hace casi 6 años

$10-30 USD

Pagado a la entrega

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

ID del proyecto: 17156338

Información sobre el proyecto

13 propuestas

Proyecto remoto

Activo hace 6 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 1 día

4,9

(2 comentarios)

1,0

13 freelancers están ofertando un promedio de $17 USD por este trabajo

@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 en 1 día

4,9

(32 comentarios)

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 en 0 día

4,9

(8 comentarios)

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 en 1 día

5,0

(17 comentarios)

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 en 1 día

5,0

(8 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 0 día