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

Hey Jerry,

that doesnt cause any errors, but doesn't update all the fields to show
10,20,30,40 etc it only adds on 15 to the name that i want to add 15
onto.

could i not be calling it or re-arrange to code.

look below

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

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

$rank = 10;

$phase2 = "UPDATE ".DB_PREFIX."".TBL_PREFIX." SET position = position +
15 WHERE ID = $ID;";

mysql_query($phase2);

$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=$position WHERE ID = {$data['ID']}");
$rank += 10;
}

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

}

• Next in forum: Re: How to upload form data containing special characters correctly?
• Prev in forum: Re: UPDATE and increment by 10
• Thread view: Re: UPDATE and increment by 10

[Reply to this message]