This is a form which members fill inside the members area:

PHP Code:
<?
session_start
();
if (!isset(
$_SESSION['username'])) {
                                    die(
'An error has ocurred. You have not logged in, or your session has expired.');
                                    exit();
}

$dbcnx = @mysql_connect("localhost""user""pass");
   if (!
$dbcnx) { 
     echo( 
"<p>Unable to connect to the " 
           
"database server at this time.</p>" ); 
     exit(); 
   }

// Select the database
   
if (! @mysql_select_db("needforcash_com") ) {
     echo( 
"<p>Unable to locate the " .
           
"database at this time.</p >" ); 
     exit(); 
   }
   
$itis "yes";
$itisnot "no";
   
$sql mysql_query("SELECT * FROM users WHERE username='$username'");

$lookup mysql_fetch_assoc($sql);


$tacticsnow $lookup['tacticsusername'];
$tacticsupdated $lookup['tacticsupdated'];

$allmylistnow $lookup['allmylistusername'];
$allmylistupdated $lookup['allmylistupdated'];

$bwlnow $lookup['bwlusername'];
$bwlupdated $lookup['bwlupdated'];

$hercunow $lookup['hercuusername'];
$hercuupdated $lookup['hercuupdated'];

$promoneynow $lookup['promoneyusername'];
$promoneyupdated $lookup['promoneyupdated'];

$safelisternow $lookup['safelisterusername'];
$safelisterupdated $lookup['safelisterupdated'];

$hisreferer $lookup['referer'];


$sqltwo mysql_query("SELECT * FROM users WHERE username='$hisreferer'");

$reflookup mysql_fetch_assoc($sqltwo);


$tacticslink $reflookup['tacticsusername'];
$allmylistlink $reflookup['allmylistusername'];
$bwllink $reflookup['bwlusername'];
$herculink $reflookup['hercuusername'];
$promoneylink $reflookup['promoneyusername'];
$safelisterlink $reflookup['safelisterusername'];

?>

<html>
.....
<form name="updatesafelists" method="post" action="updatesafelists.php">
            <table width="100%" border="0" cellpadding="1" cellspacing="3">
            
            <tr><td><b>Ad Tactics</b></td></tr>
            <tr><td><a href="http://www.adtactics.com/index.php?ac=<?=$tacticslink?>">Click here to join</a></td></tr>
            <tr><td>Enter your AdTactics username below<br>
           <? if ($tacticsupdated == $itisnot) { ?>
             http://www.adtactics.com/index.php?ac=<input name="tacticsnewlink" type="text"></td></tr>
           <? } elseif ($tacticsupdated == $itis) { ?>
             http://www.adtactics.com/index.php?ac=<input name="tacticsnewlink" type="text" value="<?=$tacticsnow?>"></td></tr>
           <? ?>

            <tr><td>&nbsp;</td></tr>
            <tr><td>&nbsp;</td></tr>

            <tr><td><b>AllMyList</b></td></tr>
            <tr><td><a href="http://www.allmylist.net/?refid=<?=$allmylistlink?>">Click here to join</a></td></tr>
            <tr><td>Enter your AllMyList ID NUMBER below<br>
           <? if ($allmylistupdated == $itisnot) { ?>
             http://www.allmylist.net/?refid=<input name="allmylistnewlink" type="text"></td></tr>
           <? } elseif ($allmylistupdated == $itis) { ?>
             http://www.allmylist.net/?refid=<input name="allmylistnewlink" type="text" value="<?=$allmylistnow?>"></td></tr>
           <? ?>

            <tr><td>&nbsp;</td></tr>
            <tr><td>&nbsp;</td></tr>

            <tr><td><b>Business World List</b></td></tr>
            <tr><td><a href="http://businessworldlist.com/members/index.cgi?<?=$bwllink?>">Click here to join</a></td></tr>
            <tr><td>Enter your Business World List username below<br>
           <? if ($bwlupdated == $itisnot) { ?>
             http://www.businessworldlist.com/members/index.cgi?<input name="bwlnewlink" type="text"></td></tr>
           <? } elseif ($bwlupdated == $itis) { ?>
             http://www.businessworldlist.com/members/index.cgi?<input name="bwlnewlink" type="text" value="<?=$bwlnow?>"></td></tr>
           <? ?>

            <tr><td>&nbsp;</td></tr>
            <tr><td>&nbsp;</td></tr>
            
            <tr><td><b>HercuList</b></td></tr>
            <tr><td><a href="http://herculist.com/members/index.cgi?<?=$herculink?>">Click here to join</a></td></tr>
            <tr><td>Enter your HercuList username below<br>
           <? if ($hercuupdated == $itisnot) { ?>
             http://www.herculist.com/members/index.cgi?<input name="hercunewlink" type="text"></td></tr>
           <? } elseif ($hercuupdated == $itis) { ?>
             http://www.herculist.com/members/index.cgi?<input name="hercunewlink" type="text" value="<?=$hercunow?>"></td></tr>
           <? ?>

            <tr><td>&nbsp;</td></tr>
            <tr><td>&nbsp;</td></tr>

            <tr><td><b>ProMoneyMail</b></td></tr>
            <tr><td><a href="http://www.promoneymail.com/member<?=$promoneylink?>">Click here to join</a></td></tr>
            <tr><td>Enter your ProMoneyMail ID NUMBER below<br>
           <? if ($promoneyupdated == $itisnot) { ?>
             http://www.promoneymail.com/member<input name="promoneynewlink" type="text"></td></tr>
           <? } elseif ($promoneyupdated == $itis) { ?>
             http://www.promoneymail.com/member<input name="promoneynewlink" type="text" value="<?=$promoneynow?>"></td></tr>
           <? ?>

            <tr><td>&nbsp;</td></tr>
            <tr><td>&nbsp;</td></tr>
            
            <tr><td><b>Safe Lister</b></td></tr>
            <tr><td><a href="http://www.safelister.com/index.cgi?id=<?=$safelisterlink?>">Click here to join</a></td></tr>
            <tr><td>Enter your Safe Lister username below<br>
           <? if ($safelisterupdated == $itisnot) { ?>
             http://www.safelister.com/index.cgi?id=<input name="safelisternewlink" type="text"></td></tr>
           <? } elseif ($safelisterupdated == $itis) { ?>
             http://www.safelister.com/index.cgi?id=<input name="safelisternewlink" type="text" value="<?=$safelisternow?>"></td></tr>
           <? ?>

            <tr><td>&nbsp;</td></tr>
            <tr><td>&nbsp;</td></tr>

            <tr><td align="center"><input type="submit" name="Submit" value="Save"></td></tr>
            </table>
            </form>
The above form submits to the following script which is where the problem is:

PHP Code:
<?
session_start
();
if (!isset(
$_SESSION['username'])) {
                                    die(
'An error has ocurred. You have not logged in, or your session has expired.');
                                    exit();
}


// Connect to the database server
   
$dbcnx = @mysql_connect("localhost""user""pass");
   if (!
$dbcnx) { 
     echo( 
"<p>Unable to connect to the " 
           
"database server at this time.</p>" );
     exit(); 
   } 
   
// Select the database
   
if (! @mysql_select_db("needforcash_com") ) {
     echo( 
"<p>Unable to locate the MarketingH2O " .
           
"database at this time.</p >" ); 
     exit(); 
   }

$sql mysql_query("SELECT * FROM users WHERE username='$username'");

$lookup mysql_fetch_assoc($sql);

$tacticsoldlink $lookup['tacticsusername'];
$allmylistoldlink $lookup['allmylistusername'];
$bwloldlink $lookup['bwlusername'];
$hercuoldlink $lookup['hercuusername'];
$promoneyoldlink $lookup['promoneyusername'];
$safelisteroldlink $lookup['safelisterusername'];

// Define post fields into simple variables


if(empty($_POST['tacticsnewlink'])) {
                                 
$tacticsnewlink $tacticsoldlink;
                                 
$tacticsupdated "no";
} else {
        
$tacticsnewlink $_POST['tacticsnewlink'];
        
$tacticsupdated "yes";
}


if(empty(
$_POST['allmylistnewlink'])) {
                                 
$allmylistnewlink $allmylistoldlink;
                                 
$allmylistupdated "no";
} else {
        
$allmylistnewlink $_POST['allmylistnewlink'];
        
$allmylistupdated "yes";
}


if(empty(
$_POST['bwlnewlink'])) {
                                 
$bwlnewlink $bwloldlink;
                                 
$bwlupdated "no";
} else {
        
$bwlnewlink $_POST['bwlnewlink'];
        
$bwlupdated "yes";
}


if(empty(
$_POST['hercunewlink'])) {
                                 
$hercunewlink $hercuoldlink;
                                 
$hercuupdated "no";
} else {
        
$hercunewlink $_POST['hercunewlink'];
        
$hercuupdated "yes";
}


if(empty(
$_POST['promoneynewlink'])) {
                                 
$promoneynewlink $promoneyoldlink;
                                 
$promoneyupdated "no";
} else {
        
$promoneynewlink $_POST['promoneynewlink'];
        
$promoneyupdated "yes";
}


if(empty(
$_POST['safelisternewlink'])) {
                                 
$safelisternewlink $safelisteroldlink;
                                 
$safelisterupdated "no";
} else {
        
$safelisternewlink $_POST['safelisternewlink'];
        
$safelisterupdated "yes";
}


$query mysql_query("UPDATE users SET tacticsusername='$tacticsnewlink', tacticsupdated='$tacticsupdated', allmylistusername='$allmylistnewlink', allmylistupdated='$allmylistupdated', bwlusername='$bwlnewlink', bwlupdated='$bwlupdated', hercuusername='$hercunewlink', hercuupdated='$hercuupdated', promoneyusername='$promoneynewlink', promoneyupdated='$promoneyupdated', safelisterusername='$safelisternewlink', $safelisterupdated='$safelisterupdated' WHERE username='$username'");

if (!
$query) {
              echo 
'Your info were NOT updated.';
} else {
           echo 
'your info were updated successfully.';
}

?>
After I submit the form, I receive "Your info were NOT updated". Meaning, that the error is in that $query line where I post to the database.

I've gone over the two scripts all day. I can't see why it's not updating the info in the database!

Strangely, the above all worked before I added the:
PHP Code:
 $tacticsupdated$allmylistupdated$bwlupdated$hercuupdated$promoneyupdated$safelisterupdated 
variables!!

Can someone spot the problem?

Thanks. I appriciate any help.