In Progress

Create PHP mysql query statement ( Advanced )

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

Skills: MySQL, PHP

See more: create php mysql add edit text, create php mysql update, create php mysql upload file script, php mysql query suggest, php mysql query sanitized, php mysql query drill, create php mysql multiple choice, php mysql query, php mysql query encoding, php mysql query sanitize, import php mysql query quickbooks, php mysql query category drop, php mysql query format table, create php mysql stories website, php mysql query table

About the Employer:
( 21 reviews ) Dallas, United States

Project ID: #14890418

Awarded to:

webdev1802

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

$30 USD in 1 day
(4 Reviews)
2.8

21 freelancers are bidding on average $25 for this job

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 in 2 days
(333 Reviews)
8.1
$25 USD in 1 day
(69 Reviews)
6.6
openeratech

I read description mentioned here and understand that you want a sql query to count game [url removed, login to view] need chat discussion then i will be able to do it quickly as required. Relevant Skills and Experience I have 5 years of More

$25 USD in 1 day
(50 Reviews)
5.3
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 More

$25 USD in 1 day
(47 Reviews)
5.3
Ahmed0666

Hi, I'm Ahmed, I have more then 12 years of experience in Design & Development. I've work for many multinational companies Work: [url removed, login to view] [url removed, login to view] [url removed, login to view] Thanks M.A Relevant Skills and Expe More

$25 USD in 1 day
(39 Reviews)
5.5
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 More

$30 USD in 1 day
(28 Reviews)
4.7
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 More

$55 USD in 1 day
(23 Reviews)
4.5
imagicaworld

Hello Relevant Skills and Experience please have a look at our portfolio link:- [url removed, login to view] Proposed Milestones $25 USD - D Stay tuned, I'm More

$25 USD in 1 day
(19 Reviews)
4.4
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 in 1 day
(26 Reviews)
3.9
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 More

$15 USD in 1 day
(16 Reviews)
3.6
$25 USD in 1 day
(7 Reviews)
3.6
Europa17

Dear,[url removed, login to view] you for reviewing me I have just read your project description carefully. I am suitable for this work and have enough power . Looking forward to your reply. Relevant Skills and Experience My sql, Larav More

$35 USD in 1 day
(2 Reviews)
2.3
mateenbhatti94

Dear sir I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. Relevant Skills and Expe More

$25 USD in 1 day
(3 Reviews)
2.6
$25 USD in 1 day
(4 Reviews)
1.9
phpmtl

​​READY TO START IMMEDIATELY AND DELIVER THE BUG FREE SOLUTION AS PER YOUR EXACT REQUIREMENT. It's a pleasure to me to place a bid on your job requirement. Please review my sample portfolio before you finalize your More

$25 USD in 1 day
(1 Review)
1.3
$25 USD in 1 day
(1 Review)
1.6
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, More

$25 USD in 1 day
(0 Reviews)
0.0
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 More

$15 USD in 1 day
(0 Reviews)
0.0
sonali1992

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

$25 USD in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0