|
Posted by version2 on 11/22/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;
}
Navigation:
[Reply to this message]
|