[Resolved] simple udate query

[yousaf931]

Hi the same query is workin on the other page..

I echo all the variable and they contains the correct vaules . dont know what is the problem

<?
	include "inc/db.inc";
	echo $logout;
	$query_no =" 
				update test set checker = 'no' where checker = 'yes' and name = '{$logout}'
			";

echo $sign ; 

if($sign = "signout") {
	mysql_db_query($db_name,$query_no, $connection);
	echo "Log Out " ;
}

?>

The problem is with $logout .. it is coming from hidden form filed it is echo the right value but problem while executing the query. Though the query is executed correctly but the problem is that it dint update the database.

Cheers,
yousaf FAYYAZ.

[barand]

Is this a test for equality ?

if ($sign = "signout")

If you want 'equals' then it should be

if($sign == "signout")

[yousaf931]

the condtion is working fine i dont what is the problem with the query.

If hard code the value than it works fine otherwise it dint update the filed in database.

Cheers,
yousaf FAYYAZ.

[yousaf931]

the problem is resloved.

$trim_variable = trim($logout);

🙂

Cheers,
yousaf FAYYAZ.