Not updating.

[newttster]

For the life of me, I can not figure out why this is not updating the db. What am I missing?

 

<?php
include "globals.php";
$direction=array(
'North' => 'north',
'West' => 'west',
'East' => 'east',
'South' => 'south',);
$dir=$direction[$_POST['direction']];

if($dir=="north")
{
$db->query("UPDATE catacomb SET north=north+1 WHERE userid=$userid");
}
elseif($dir=="west")
{
$db->query("UPDATE catacomb SET east=east-1 WHERE userid=$userid");
}
elseif($dir=="east")
{
$db->query("UPDATE catacomb SET east=east+1 WHERE userid=$userid");
}
elseif($dir=="south")
{
$db->query("UPDATE catacomb SET north=north-1 WHERE userid=$userid");
}
echo"<table align='center'>
<tr >
<td ><th colspan='15'>
<a href='catacomb.php?direction=north'>North</a><br /><br /></td></tr>
<tr >
<td ><th>
<a href='catacomb.php?direction=west'>West</a>
<th>
<th>
<th>
<th>
<th>
<th>
<th>
<th>
<th>
<th>
<th>
<th>
<th>
<a href='catacomb.php?direction=east'>East</a><br /></td></tr>
<tr >
<td ><th colspan='15'><br />
<a href='catacomb.php?direction=south'>South</a><br /></td></tr></table>";

$h->endpage();
?>

[Ben Nash]

Is everything spelt right in phpmyadmin?

[newttster]

Is everything spelt right in phpmyadmin?

Yes it certainly is.

[bluegman991]

Lol. Your using $_POST when you should be using $_GET

[newttster]

Thanks blue. I have changed the Post to Get. I had tried this before and neither had worked. What I had to do was take out the array.

My next question is once my "direction" gets to the maximum number; How do I turn the link off?

Edited February 27, 2012 by newttster