i think i have a problem.... can you help me? :)

[shirley25]

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

 

 

[Altrozero]

It probably means that the row and field you are requesting doesn't exist, in other words when no rows are found in your query, mysql_result can't get anything. You can solve this my going...

 

$phase = false;

$query_result = mysql_query("SELECT `phase` FROM `as_support` WHERE `mission` = '$var2'");

 

if(mysql_num_rows($query_result) > 0)

$phase = mysql_result($query_result, 0, 0);

 

if($phase !== false) {

....

[shirley25]

i gess you r right but.. the idea is that have a page with a blank bar that i write a word in it. this word is "mission = var2" . sorry for asking.. what after the "if($phase !== false) {

.... ?

tnx

[Altrozero]

Just the rest of your code, I basically replaced the line

 

if ($phase = mysql_result(mysql_query("SELECT `phase` FROM `as_support` WHERE `mission` = '$var2'"),0,0))

 

with what I posted. It should stop giving you the warning then.

[shirley25]

now it doesn't work... it runs without an erro for a minet but then stops.. and i don't see that it is updating on mysql.