# Game Database

**URL:** <https://forum.kirupa.com/t/game-database/320472>\
**Category:** programming\
**Created:** [March 24, 2011, 12:18pm UTC](https://forum.kirupa.com/t/game-database/320472 "2011-03-24T12:18:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jason116](https://avatars.discourse-cdn.com/v4/letter/j/7993a0/32.png) [@jason116](https://forum.kirupa.com/u/jason116)\
**Post date:** [March 24, 2011, 12:18pm UTC](https://forum.kirupa.com/t/game-database/320472/1 "2011-03-24T12:18:03Z")

</div>

Hi,

I am developing an RPG game in Unity 3D where player stats, quests, items etc are stored on a mySQL database.

Tables:

\*\*Players \*\*  
id  
player\_name  
email\_address  
password

**Quests**  
id  
npc\_name  
quest\_name  
quest\_text  
reward\_id  
required\_items

\*\*Player Stats  
\*\*id  
player\_id  
completed\_quests

\*\*Code for returning quests to the game  
\*\*

```php

    if(isset($_GET['name'])) {
        $player_id = 1;
        $name = $_GET['name'];
        $query = "SELECT * FROM `Quests` WHERE `npc_name` = '$name'";
        $result = mysql_query($query) or die('Query failed: ' . mysql_error());
    
        $num_results = mysql_num_rows($result); 
    
        for($i = 0; $i < $num_results; $i++)
        {
             $row = mysql_fetch_array($result);
             echo $row['quest_name'] . "*" . $row['quest_text'] . "*" . $row['npc_name'] . "*" . $row['required_items'];
        }
    }

```

What I would like to do is return quests that the player has not completed. Could someone advise me the best approach.

Thanks

Jason