How to Display MySQL Data in a Grid

[arwebdesign]

Hi guys. I'm trying to build a games site for a friend. Currently, the front-end (HTML/CSS) of the site is done. Now, I want to make a way for him to easily add games to the site. Ideally, I'd like to make a database with the following columns: ID, Name, Category, Link, Thumbnail_Link. So, those would be the ID, name of the game, the category, a link to the game, and a link to the 50x50 thumbnail image respectively. Then, using PHP, I'd like to call the first x number (not sure what it will be yet, let's say 50) and format it as a grid in the following way: There's the thumbnail image followed by the game name, and they're all a clickable link to the game URL. Is this possible? How would I go about doing this? I've already set up a database for a login module to the site, so each page has already opened a connection to the MySQL database. However, I've only ever done basic PHP for mail forms and am otherwise extremely new to it, and am especially new to MySQL.

Could anyone walk me through how to do this or even give me a quick example script to work off of?

Thanks, any of your time is greatly appreciated!

[Krik]

By grid I assume you mean table.

Basically loop through the returned results like so

<table>
    <tr>
        <td>Thumbnail</td>
        <td>Name</td>
    </tr>
<?php
$result = mysql_query("SELECT * FROM `Games` LIMIT 50");
while ($row = mysql_fetch_array($result)) {
?>
    <tr>
        <td><a href="<?php echo $row['Link']; ?>"><img scr="<?php echo $row['Thumbnail_Link']; ?>" /></a></td>
        <td><a href="<?php echo $row['Link']; ?>"><?php echo $row['Name']; ?></a></td>
    </tr>
<?php
}
?>
</table>