Create PHP mysql query statement ( Advanced )

Виконано Опубліковано %project.relative_time Оплачується при отриманні

$10-30 USD

Оплачується при отриманні

Виконано Оплачується при отриманні

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

ID Проекту: #14890418

Про проект

18 заявок(-ки) Дистанційний проект Остання активність 6 роки(ів) тому

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та часові рамки
Отримайте плату за вашу роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними

Доручено:

Світлина профілю webdev1802
webdev1802

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

$30 USD за 1 день
(15 відгуків(-и))
4.5

18 фрілансерів(-и) готові виконати цю роботу у середньому за $25

Світлина профілю searchtechnow
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 за 2 дні(-в)
(384 відгуків(и))
8.2
Світлина профілю Nikiit31
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 Більше

$25 USD за 1 день
(67 відгуків(и))
6.2
Світлина профілю jiitendra
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 Більше

$55 USD за 1 день
(39 відгуків(и))
6.0
Світлина профілю cherrystuart83
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 за 1 день
(64 відгуків(и))
5.2
Світлина профілю hemantjhalani
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 Більше

$30 USD за 1 день
(45 відгуків(и))
5.3
Світлина профілю Virend7586
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 Більше

$15 USD за 1 день
(39 відгуків(и))
4.6
Світлина профілю Bhawandtu
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 Більше

$15 USD за 1 день
(8 відгуків(и))
2.4
Світлина профілю sonali1992
sonali1992

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

$25 USD за 1 день
(0 відгуків(и))
0.0
Світлина профілю mohitsid31
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, Більше

$25 USD за 1 день
(0 відгуків(и))
0.0
Світлина профілю Greenek341
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 за 1 день
(0 відгуків(и))
0.0
Опублікувати схожий проект