i'm getting this erro
"Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /***/***/*****.php on line 278
not an active session, starts new"
this is the code:
if ($phase = mysql_result(mysql_query("SELECT `phase` FROM `as_support` WHERE `mission` = '$var2'"),0,0))
{
if ($phase=='5') {
// mysql_query("DELETE FROM `as_support` WHERE `mission` = '$var2'");
// header("Location: https://www.**********/*******/*******.php");
}
else {
echo date('h:i:s') . ": PHASE is $phase<br />";
echo "\$var1=$var1,\$var2=$var2<br />";
}
}
else {
echo "not an active session, starts new<br />";
echo "\$var1=$var1,\$var2=$var2<br />";
mysql_query("INSERT INTO `as_support` (`mission`, `phase`) VALUES ('$var2', '0')") OR DIE(mysql_error());
the first line is line no. 278
can someone please tell me what to do?
tnx
shirley