mysql_fetch_assoc(); help needed

[marcus]

Ok, I get the normal

[code]
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zack/public_html/rpg/inc/addxp.php on line 6
[/code]

Code:

[code]
<?php
$connection = mysql_connect(localhost,zack_rpg,passwordhere);
$db = mysql_select_db(zack_rpg,$connection);
$sql = "SELECT * stats WHERE stats.id=$_COOKIE[id]";
$res = mysql_query($sql);
$res2 = mysql_fetch_assoc($res);
$xp = $res2[xp];
$rand = rand(0,10);
$xpadd = "$xp + $rand";
$sql2 = "UPDATE stats SET xp = `$xpadd` WHERE stats.id=$_COOKIE[id]";
$res3 = mysql_query($sql2);
?>
[/code]

[ToonMariner]

$sql = "SELECT * stats WHERE stats.id=$_COOKIE[id]";


change to

$sql = "SELECT * stats WHERE id = " . $_COOKIE[id];

[marcus]

Didn't do anything but keep the error the same.

[marcus]

nevermind, got it working -locks-