Video Game list

I have a SQLite database where I store games that I have played. This database contains title of the game, platform on which I have played or emulated the game, my grade and short description of what do I think of the game. Grading system works like this: 5 means mixed feelings, 1 worst games, 10 best games. Happy reading :3

Sort By Name (A-Z) Name (Z-A) Grade (Lowest to Highest) Grade (Highest to Lowest)

prepare($query); $stmt->bindValue(':search', '%' . $search . '%', SQLITE3_TEXT); // Execute the query $results = $stmt->execute(); // Loop through the results and display them in the table while ($row = $results->fetchArray(SQLITE3_ASSOC)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

Game Name	Platform	Grade	Description
{$row['name']}	{$row['platform']}	{$row['grade']}	{$row['description']}