[RESOLVED] Updating some data in DB

[kostis12345]

Ok,I've made a script that updates data(targetid) in the database based on a user's id.First I want to make it so I can update all of the user's "targetid"s(as an admin feature) and lastly I want to make it so that if a user is the last in the DB his targetid becomes 1
Here's my code

<?php
session_start();
/**
 * @author kostis
 * @copyright 2009
 */
 if (isset($_SESSION['Alias']))
 {
 include ('database/connect.php');
 $target = mysql_query("SELECT * FROM players WHERE alias = '" .$_SESSION['Alias'] . "'");
		mysql_real_escape_string($_SESSION['Alias'] . "'");
		$result = mysql_fetch_array($target);
$id=$result['id'] +1;
mysql_query("UPDATE players SET Targetid = '$id' WHERE Alias = '" .$_SESSION['Alias'] . "'") or die(mysql_error());

}
else
{
	echo "session's not working";
}
?>

If you need anymore info,just tell me.
I'd really appreciate your help.

Thanks in advance

[devinemke]

are you simply trying to update the Targetid to be the id + 1? if so you can do this in a single query:

$sql = "UPDATE players SET Targetid = id + 1 WHERE Alias = '" . $_SESSION['Alias'] . "'";

[kostis12345]

There are 2 columns in the DB(that are of interest here),id and targetid
I want target id to be id +1
I've done that but I want a general script that updates all of their "targetid"s based on their id
For example we have this table
Name id targetid
test1 1 0
test2 2 0
test3 3 0
test4 4 0

I want a script that will automatically update all of them to

Name id targetid
test1 1 2
test2 2 3
test3 3 4
test4 4 1
the test4 user's(last one in the table) targetid,I want it to be the id of the first one in the table

Thanks in advance