affnetguru

edit your table to something like [icode]<table cellpadding="15" cellspacing="15" bgcolor="red">[/icode] OR with(RGB) [icode]<table cellpadding="15" cellspacing="15" bgcolor="#FF0000">[/icode]

do something like this (not exactly like this) [code=sql]"SELECT * FROM table1 LEFT JOIN table2 ON table1.col1=table2.col2 WHERE table1.col1=$var1";[/code]

after this line [icode]$sql = "UPDATE userinformation SET activationkey = ' ', status='activated' WHERE (id = $row[id])";[/icode] execute the query [icode]mysql_query($sql) or die(mysql_error());[/icode]