Move the records up/down (sort) in database PHP

Hi, I'm trying to sort the records in a table by using an 'up' and 'down' buttons (images).

Basically it should swap the position of the two records in the database:
example records A B C D - When you click the 'up' button for C the records should now read A C B D.

I'm using 'id' which is the primary key and 'order' (integer with default as 0) which should hold the value of the order of the records.

Been struggling for a long time on this one, your help would be really appreciated!!! :D

I'm attaching the sort_toptip.php page as a code snippet, the code with the buttons which call it are below:

---------------------------------------------------

<?php

// Create an object (instance) of the DbConnector
$connector = new DbConnector();

// Execute the query to retrieve articles
$result = $connector->query('SELECT id,day,month,year,location,venue FROM TopTips ORDER BY id ASC LIMIT 0,1000');

// Get an array containing the results.
// Loop for each item in that array
echo '<h3>Top Tips</h3>';

while ($row = $connector->fetchArray($result)){

echo '<h6>';
echo '<span class="courselist">';
echo $row['day'];
echo '</span>';
echo '<span class="courselist">';
echo $row['month'];
echo '</span>';
echo '<span class="courselist">';
echo $row['year'];
echo '</span>';
echo '<span class="courselist">';
echo $row['location'];
echo '</span>';
echo '<span class="courselist">';
echo $row['venue'];
echo '</span>';
echo '<span class="courselist">';
echo '<a href="edit_toptip.php?id='.$row['id'].'">EDIT</a> /';
echo '</span>';
echo '<span class="courselist">';
echo '<a href="delete_toptip.php?id='.$row['id'].'">DELETE</a>';

echo '<span class="sorting"> ';
echo ' <a href="sort_toptip.php?id='.$row['id'].'&move=up"><img src="../images/up.gif" border="0" /></a>';
echo '</span>';

echo '<span class="sorting">';
echo '<a href="sort_toptip.php?id='.$row['id'].'&move=down"><img src="../images/down.gif" border="0" /></a>';
echo '</span>';

echo '</span>';
echo '</h6>';

}
?>
Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:

<?php
 
// Require the database class
require_once('../includes/DbConnector.php');
 
// Create an object (instance) of the DbConnector
$connector = new DbConnector();
 
 
if (isset($_GET['move']) && $_GET['move'] == "up"){
 
$connector->query("UPDATE `TopTips` SET `order` = `order` - 1 WHERE `order` = " . $_GET['order']+1);
$connector->query("UPDATE `TopTips` SET `order` = `order` + 1 WHERE `id` = " . $_GET['id']);
 
print "<meta http-equiv=\"refresh\" content=\"0;URL=index.php\">";
 
}
 
if (isset($_GET['move']) && $_GET['move'] == "down"){
 
$connector->query("UPDATE `TopTips` SET `order` = `order` + 1 WHERE `order` = " . $_GET['order']-1);
$connector->query("UPDATE `TopTips` SET `order` = `order` - 1 WHERE `id` = " . $_GET['id']);
 
print "<meta http-equiv=\"refresh\" content=\"0;URL=index.php\">";
 
}
 
 
?>