Hjælp til omplaciring?
Hej eksperter.Jeg har denne kode, som går ind i min db og ændre alle tallene i felterne "plac" med -1 eller +1, det gør så jeg kan bestemme hvilken rækkefølge nogen priser skal lægge i, men nu vil jeg gerne be om hjælp til at lave så den gør præcis det samme med feltet "id" i min tabel.
koden ser sådan ud:
if(is_numeric($_GET['id']) && !empty($_GET['plac']))
{
$currentSort = 0;
$currentID = mysql_real_escape_string($_GET['id']);
$moveSort = 0;
$moveID = 0;
$query = mysql_query("SELECT plac FROM priser WHERE id = " . $currentID . " LIMIT 1");
if(mysql_num_rows($query)>0)
{
$currentSort = mysql_result($query,0);
}
switch($_GET['plac'])
{
case "op":
$query = mysql_query("SELECT id, plac FROM priser WHERE plac < ".$currentSort." ORDER BY id DESC LIMIT 1");
break;
case "ned":
$query = mysql_query("SELECT id, plac FROM priser WHERE plac > ".$currentSort." ORDER BY id ASC LIMIT 1");
break;
default:
$moveSort = 0;
$moveID = 0;
}
if(mysql_num_rows($query)>0)
{
$row = mysql_fetch_assoc($query);
$moveID = $row['id'];
$moveSort = $row['plac'];
}
if($moveSort > 0)
{
$query = mysql_query("UPDATE priser SET plac = ".$moveSort." WHERE id = ".$currentID." LIMIT 1");
$query = mysql_query("UPDATE priser SET plac = ".$currentSort." WHERE id = ".$moveID." LIMIT 1");
}
}
echo "<table width=\"100%\" cellpading=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\">";
echo "<tr bgcolor=\"$bgcolor\" onMouseOver=\"this.bgColor='$over';\" onMouseOut=\"this.bgColor='$bgcolor';\">";
echo "<td width=\"10%\" class=\"main_txt\"><b>Nr.:</b></td>";
echo "<td width=\"75%\" class=\"main_txt\"><b>Varer:</b></td>";
echo "<td width=\"15%\" class=\"main_txt\"><b>Placering:</b></td>";
echo "</tr>";
$query = mysql_query("SELECT * FROM priser ORDER BY plac");
if(mysql_num_rows($query)>0)
{
$a = 0;
while($row = mysql_fetch_assoc($query)) {
$a++;
if($a%2 == 0) {
$bgcolor = "#f4f3f3";
}else{
$bgcolor = "#EBEBEB";
}
$over = '#ded7c7';
echo "<tr bgcolor=\"$bgcolor\" onMouseOver=\"this.bgColor='$over';\" onMouseOut=\"this.bgColor='$bgcolor';\">";
echo "<td width=\"7%\" class=\"main_txt\"><b>" . $row['nr'] . "</b></td>";
echo "<td width=\"83%\" class=\"main_txt\">" . $row['vare'] . "</td>";
echo "<td width=\"10%\" class=\"main_txt\"><div align=\"right\"><a href=\"".$_SERVER['PHP_SELF']."?id=".$row['id']."&plac=op\"><img src=\"images/op.gif\" border=\"0\" alt=\"Flyt op\"></a> <a href=\"".$_SERVER['PHP_SELF']."?id=".$row['id']."&plac=ned\"><img src=\"images/ned.gif\" border=\"0\" alt=\"Flyt ned\"></a> </div></span></td>";
echo "</tr>\n";
}
}
else
{
echo "<tr><td>Ingen priser</td></tr>\n";
}
echo "</table>";
på forhånd tusind tak for hjælpen
