Posted by version2 on 12/16/49 11:57

I realised that before your last post :)

after making that change i removed the queery where i add 15 to a
number just to see if that query that you gave me works but
unfortunatley it doesnt

is it missing the query or something.

if ($_GET["action"] == "moveup") {

$muscleName=$_GET['muscleName'];
$ID = $_GET["ID"];


$rank = 10;
$result1 = mysql_query("SELECT ID,position FROM
".DB_PREFIX."".TBL_PREFIX." ORDER BY position");

while ($data = mysql_fetch_array($result1)) {
$result2 = mysql_query("UPDATE ".DB_PREFIX."".TBL_PREFIX." SET position
= $rank WHERE ID = {$data['ID']}");
$rank += 10;
}

header("Location: index_exercise.php?ID=$muscleName");
exit;

}

[Back to original message]