Cookie value not updating

[Sharif]

Say I run setcookie('sid', session_id(), time()+604800, '/', 'onlyonxbox.net'), and then close browser, then i open browser again and run that code again, wouldn't it replace the value of sid?

This is the code and it is not working:

$sql = "UPDATE ";
$sql.= "sessions ";
$sql.= "SET ";
$sql.= "sid = '" . session_id() . "', time = now() ";
$sql.= "WHERE ";
$sql.= "sid = '" . $_COOKIE['sid'] . "'";
$query = mysql_query($sql);

setcookie('sid', $sid, time()+604800, '/', 'onlyonxbox.net');

unset($sql);
unset($query);

$sql = "SELECT ";
$sql.= "DATE_FORMAT(time, '%m/%d/%Y at %l:%i:%s %p') AS timestamp ";
$sql.= "FROM ";
$sql.= "sessions ";
$sql.= "WHERE ";
$sql.= "sid = '" . $_COOKIE['sid'] . "'";
$query = mysql_query($sql);

There is a lot of other code in this script but this part executes if the 'sid' cookie exists, what this does is it first updates the sessions table with the new session id with the exisiting sid cookie and then it is supposed to update the sid cookie with the new session id as well but what really happens is that the table does update with the new session id, but the cookie stays with the old on and the second query doesn't return a correct result because it is trying to get a record for the old session id which doesn't exist anymore. Any ideas on how I can get the sid cookie to update after the table is updated?

[swr]

Where you have 'onlyonxbox.net' try '.onlyonxbox.net' instead. I seem to recall reading somewhere that the cookie's domain requires two dots.

Also, remember that the $COOKIE array won't be affected by [man]setcookie[/man] until the next_ page.

[Frederick]

setcookie('sid', $sid, time()+604800, '/', 'onlyonxbox.net');

The one thing that is wrong with your cookie is that the forward slash is for your primary domain and the following section where you have onlyonxbox.net is meant for sub-directory of that primary domain.

Should be

setCookie('sid', $sid, time()+(604800), '/', 'DirectoryName',0);