Create PHP mysql query statement ( Advanced )

Completado Publicado hace 6 años Pagado a la entrega
Completado Pagado a la entrega

Our client would like to have an advanced PHP mysql query to get the counts for specific games based on the games id.

Example: The table holds multiple games, each game is identified by the gameid. The client wants to create a query statement that will get all the games and gameid from the

database then display the specific count results for each game without creating so many query statements.

DB Table Name: Games

DB Columns: `gametitle`,`gameid`,`online`

The gameid identifies the specific games, ex: 312, 932, 0010, 392. Each id is a different game and each game has a different count.

The client wants to display the count (gametitle) for each gameid in the db. The final result will be a php echo that will display the specific game results.

Example: php echo $results[312] --- This will display the count for the gameid 312

php echo $results[932] --- This will display the count for gameid 932.

Summary: The client wants to create a query statement that will get the counts for each gameid without creating multiple query calls to the server.

All our jobs are paid once they are complete. Check our reviews.

Happy Bidding

MySQL PHP

Nº del proyecto: #14890418

Sobre el proyecto

18 propuestas Proyecto remoto Activo hace 6 años

Adjudicado a:

webdev1802

I have expertise in database. Relevant Skills and Experience php,mysql Proposed Milestones $30 USD - .

$30 USD en 1 día
(15 comentarios)
4.5

18 freelancers están ofertando un promedio de $25 por este trabajo

searchtechnow

Do we need to get count based on 2 table? It's really easy job for me. Please initiate chat so that we can discuss and start it asap. Look forward for your response. Regards

$25 USD en 2 días
(384 comentarios)
8.2
Nikiit31

Hi, I have read your requirement and understood the query, can start now and can create MySQL query statement, kindly initiate chat and share more details I have 6+ years of working experience with PHP, MySQL, Word Más

$25 USD en 1 día
(67 comentarios)
6.2
jiitendra

Hi, I have reviewed your requirement and I can do this job as per your requirement. I have a advanced skills in WORDPRESS ,Joomla, Angular JS ,PHP, Codeigniter,MYSQL, Ajax,Joomla,JavaScript, API Integration,Plugin Más

$55 USD en 1 día
(39 comentarios)
6.0
cherrystuart83

i can do it. Relevant Skills and Experience PHP, Wordpress, HTML5, CSS3, JavaScript/JQuery, Ajax, Bootstrap V1, V2, V3, PSD to HTML. Proposed Milestones $20 USD - as we discuss

$20 USD en 1 día
(64 comentarios)
5.2
hemantjhalani

Hello, I am expert in building a complex query so I am one of the suitable candidate for this project. Feel free to contact me. Thanks Hemant Relevant Skills and Experience php and mysql Proposed Milestones $30 USD Más

$30 USD en 1 día
(45 comentarios)
5.3
Virend7586

I have 5 years experience of Android App, phoneGap, Wordpress, Php, Codeigniter, Html, CSS, Bootstrap, conversion of PSD to HTML & WORDPRESS with fully responsive, Js. Relevant Skills and Experience Android App, phone Más

$15 USD en 1 día
(39 comentarios)
4.6
Bhawandtu

I have 2+ years of experience in PHP. I have worked on both MySQL and PostgreSQL and well versed with simple to complex queries. I believe I am the right person for this task. Relevant Skills and Experience PHP, MySQL Más

$15 USD en 1 día
(8 comentarios)
2.4
sonali1992

i have 3+ years in PHP with codeigniator framework Stay tuned, I'm still working on this proposal.

$25 USD en 1 día
(0 comentarios)
0.0
mohitsid31

Hi, I am an PHP Developer, I have overall experience around 5+ yrs. Overall i am expertise in these Technologies:- PHP, CakePHP, Angular 2-4, Html 5, Sass, Jquery, JavaScript, Twitter Bootstrap, Responsive Design, Más

$25 USD en 1 día
(0 comentarios)
0.0
Greenek341

Hello, I can help you with this query situation easily, please contact me when you have the time to talk, have a great one! :)

$10 USD en 1 día
(0 comentarios)
0.0