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 --- This will display the count for the gameid 312
php echo $results --- 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.
21 freelancers are bidding on average $25 for this job
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
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