I dunno wht i am doing wrong plz help
my query is
if($_REQUEST['action']=="activate")
{
$date2 = date("Y-m-d", time());
//$mysqldate = date( 'Y-m-d H:i:s', $phpdate );
//$phpdate = strtotime( $mysqldate );
if(mysql_query("update members set activated = $date2 and status = 1 where id = {$_REQUEST[id]}"))
{
//$myquery = mysql_query("update members set activated = FROM_UNIXTIME($phpdate) and status = 1 where id = {$_REQUEST['id']}");
//echo $myquery;
echo "<font color='red'/>
The Member has been activated. $date2 - $_REQUEST[id]</font>";
}
else
{
echo " Could Not Activate member. Try later. " ;
}
}
It displays " The Member has been activated. 2009-02-09 - 1" so it gives the positive answer but neither does it update status nor date. what do i do?
I even tried using “$date2” but doesnot wrk.