PHP - X Y Coordinate Grid, Using Php With Data In Sql

How do I create a coordinate map in php? I created ordered pairs and I want to plot them on a grid. Grid is about 200000x200000.

Need help in achieving a data entry grid.
I have two tables am_user (idam_user, name) and am_activity (idam_act, act) with the data
Data for am_user is
1, John
2, Mary
3, Kate
Data for am_activity is
1, Cooking
2, Cleaning
3, Painting
I have a third table that stores the role played by each user for the activities. am_role (idam_role, role)
1, Manage
2, Observe
3, Documents
I want my User table to be my header, Activity table to my 1st column and Role table to populate the data grid
John Mary Kate Cooking Manage Document Observe Cleaning Document null Manage Painting Observe Document Manage
By putting two while loops I am able to generate the header and 1st column but I need help in populating the grid in between.
Also I want my data entry area (rows and column besides header and 1st column) to have lookup where they can select values from the am_role table.
So, John can "Manage" "Painting" tomorrow if he wants to
The two while loops are
Code: [Select]
$query = "select idam_user, Name ";
$query .= " from am_user ";
        $result = mysql_query($query) or die(mysql_error()); 
               
        // display data in table
        echo "<center>";
        echo "<table>";
        echo "<tr>";
        echo "<th></th>";
       

        // loop through results of database query, displaying them in the table
        while($row = mysql_fetch_array( $result )) {
               
                // echo out the contents of each row into a table
                echo '<th>' . $row['name'] . ' ';
                echo "</th>";
        }
        echo "</tr>";

$query = "select idam_act, act ";
$query .= " from am_activity ";
        $result = mysql_query($query) or die(mysql_error());                 
        // display data in table
       

        // loop through results of database query, displaying them in the table
        while($row = mysql_fetch_array( $result )) {
               
                // echo out the contents of each row into a table
                echo '<tr>';
                echo '<td>' . $row['act'] . '</td>';
                echo '</tr>';
        }
       
       
        // close table>
        echo "</table>";
        echo "</center>";


Please advise if this thought is realistic and how can I achieve it.
Thanks in anticipation.

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 make 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!

Hey folks!

I am looking to build a small adventure game in PHP and the key to this will be a 3x3 (or possibly bigger) grids of squares, with the user situated in the centre.

I therefore need to be able to figure out the co-ords of the surrounding squares.

Presumably I will need to define the size of the master grid, then using the co-ords of the current square (defined from a database containing the users location), calculate the co-ords for the surrounding 8 grid squares.

Has anyone had any experience with this? Where should I start? (Maths isn't my strong point tbh, but I can pick things up quickly)

Thanks in advance!

EDIT - in case it wasn't too clear, the "world map" would be something like 1000x1000 squares, but the player can only see the 3x3 grid  at there location.

I want to pull the last 8 entries from a database.

Code: [Select]
$result = mysql_query("SELECT * FROM `sites` ORDER BY id DESC LIMIT 8");
The problem is when I ORDER BY ASC the elements are displayed fine but in ORDER BY DESC the are messed up. Why? and how do I fix it

ORDER BY DESC


ORDER BY ASC


CSS

Code: [Select]
html {
font-family: segoe ui, arial, helvetica, sans-serif;
height: 100%;
overflow: hidden;
}

body {
background-image: linear-gradient(bottom, #FFFFFF 16%, #E8E8E8 79%);
background-image: -o-linear-gradient(bottom, #FFFFFF 16%, #E8E8E8 79%);
background-image: -moz-linear-gradient(bottom, #FFFFFF 16%, #E8E8E8 79%);
background-image: -webkit-linear-gradient(bottom, #FFFFFF 16%, #E8E8E8 79%);
background-image: -ms-linear-gradient(bottom, #FFFFFF 16%, #E8E8E8 79%);
background-image: -webkit-gradient(linear,left bottom,left top,color-stop(0.16, #FFFFFF),color-stop(0.79, #E8E8E8));
background-repeat: no-repeat;
}

#sites {
width: 56%;
padding: 10px;
position: relative;
left: 50%;
margin-left: -29%;
top: 150px;
}

.siteWidget {
margin: 5px;
padding: 10px;
width: 200px;
float: left;
text-align: center;
-webkit-transition: all 0.25s ease-in-out;
    -moz-transition: all 0.25s ease-in-out;
}

.siteWidget .img {
height: 150px;
-moz-box-shadow: 2px 2px rgba(0,0,0,0.25);
-webkit-box-shadow: 2px 2px rgba(0,0,0,0.25);
box-shadow: 2px 2px rgba(0,0,0,0.25);
margin-bottom: 10px;
}

.siteWidget .img:hover {
box-shadow: 0 0 10px rgba(0, 0, 0, 1);
    -webkit-box-shadow: 0 0 10px rgba(0, 0, 0, 1);
    -moz-box-shadow: 0 0 10px rgba(0, 0, 0, 1);
}

a {
text-decoration: none;
colour: black;
}

a:visited {
color: black;
}

a:hover {
color: #e90000;
}

h3 {
margin: 0;
padding: 0;
}


html/PHP
Code: [Select]
<?
ob_start();
include('config.php');
?>
<!DOCTYPE HTML>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<title>Site Selector</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<?php
if (!isset($_POST['submit']))
{
?>
<form action="index.php" method="post">
<table>
<tr>
<td>
<h3>Add New Site: </h3>
</td>
<td>
<input type="text" name="siteName" placeholder="Name" />
</td>
<td>
<input type="text" name="siteUrl" placeholder="URL" />
</td>
<td>
<input type="submit" name="submit" value="Add Site" />
</td>
</tr>
</table>

</form>

<div id="sites">

<?php
//load the pages from the Database
$result = mysql_query("SELECT * FROM `sites` ORDER BY id ASC LIMIT 8");

if (mysql_num_rows($result) == 0)
{
    echo 'No entries';
}
else
{
    while ($row = mysql_fetch_assoc($result))
    {
    ?>
    <div class="siteWidget">
<div class="img"><a href="http://<?=$row['url']?>"><img src="http://pagepeeker.com/t/m/<?=$row['url']?>" border="0"></a></div>
    <a href="http://<?=$row['url']?>" name="<?=$row['name']?>"><?=$row['name']?></a>
    </div>
    <?
    }
}
}
else
{
//Get the data
$siteName = secure($_POST['siteName']);
$siteUrl = secure($_POST['siteUrl']);

if (!$siteName || $siteUrl)
{
header("Location: index.php");
}
else
{
$query = mysql_query("INSERT INTO `sites` (name, url) VALUE($siteName, $siteUrl)");

if (mysql_num_rows($query))
{
header("Location: index.php");
}
else
{
echo 'Site not Added!<br />';
echo '<a href="index.php">Go Back</a>';
}
}
}
?>
<div style="clear:both;"></div>
</div>
</body>
</html>

HTML ONLY
Code: [Select]

<!DOCTYPE HTML>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<title>Site Selector</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<form action="index.php" method="post">
<table>
<tr>
<td>
<h3>Add New Site: </h3>
</td>
<td>
<input type="text" name="siteName" placeholder="Name" />
</td>
<td>
<input type="text" name="siteUrl" placeholder="URL" />
</td>
<td>
<input type="submit" name="submit" value="Add Site" />
</td>
</tr>
</table>

</form>

<div id="sites">

    <div class="siteWidget">
<div class="img"><a href="http://google.ca"><img src="http://pagepeeker.com/t/m/google.ca" border="0"></a></div>
    <a href="http://google.ca" name="Google">Google</a>
    </div>
        <div class="siteWidget">
<div class="img"><a href="http://facebook.com"><img src="http://pagepeeker.com/t/m/facebook.com" border="0"></a></div>
    <a href="http://facebook.com" name="Facebook">Facebook</a>
    </div>
        <div class="siteWidget">
<div class="img"><a href="http://coldcallradio.com"><img src="http://pagepeeker.com/t/m/coldcallradio.com" border="0"></a></div>
    <a href="http://coldcallradio.com" name="Cold Call Radio">Cold Call Radio</a>
    </div>
        <div class="siteWidget">
<div class="img"><a href="http://redbarradio.net"><img src="http://pagepeeker.com/t/m/redbarradio.net" border="0"></a></div>
    <a href="http://redbarradio.net" name="Red Bar Radio">Red Bar Radio</a>
    </div>
        <div class="siteWidget">
<div class="img"><a href="http://youtube.com"><img src="http://pagepeeker.com/t/m/youtube.com" border="0"></a></div>
    <a href="http://youtube.com" name="YouTube">YouTube</a>
    </div>
        <div class="siteWidget">
<div class="img"><a href="http://coldcallradio.com/wp-admin"><img src="http://pagepeeker.com/t/m/coldcallradio.com/wp-admin" border="0"></a></div>
    <a href="http://coldcallradio.com/wp-admin" name="Cold Call Radio Admin Panel">Cold Call Radio Admin Panel</a>
    </div>
        <div class="siteWidget">
<div class="img"><a href="http://apple.ca"><img src="http://pagepeeker.com/t/m/apple.ca" border="0"></a></div>
    <a href="http://apple.ca" name="Apple Canada">Apple Canada</a>
    </div>
        <div class="siteWidget">
<div class="img"><a href="http://trios.com"><img src="http://pagepeeker.com/t/m/trios.com" border="0"></a></div>
    <a href="http://trios.com" name="triOs College">triOs College</a>
    </div>
    <div style="clear:both;"></div>
</div>
</body>
</html>