Friend-request script with an error hidden somewhere i cant find... Help please

[nicholasolsen]

 

Im working on a "Friend-request"-script, but something is wrong in my "answer"-script...

 

See the script below:

 

    if (isset($_POST['submit_ansReq_answer'])) {
    
        $answer = $_POST['ansReq_what'];
        $uid= $_SESSION['userid'];
        $fid= $_POST['fid'];
        
        
        $db=friend_db;
        $dbname=bannaky_basic;
        include('config.php');
        
        
        ///////////// IF ACCEPTED
        
        if ($answer == "acceptReq") {
        
        $reqStat = "YES";
        $reqEcho = "Answered YES";
        
        }
    
        ///////////// ELSE IF DENIED
    
        else if ($answer == "denyReq") {
        
        $reqStat = "NO";
        $reqEcho = "Answered NO";
        
        }
        
        $query = "UPDATE $db SET req_accept='$reqStat' WHERE friend_id='$uid' AND user_id='$fid'";
            
            mysql_query($query);
            
            
            echo "$reqEcho";

 

 

If the user hits the Accept-button, everything works fine and is registered in the SQL database. But when hitting the Deny-button nothing happens... I get to the page and $regEcho works, but $reqStat=NO; wont save in the SQL database...

 

Probably a simple solution to this that im not seeing.... Please help me out before i loose my mind.

[nicholasolsen]

If someone could take a look at the code i entered above i would really appreciate it.

 

Thanks

[fife]

put

 

 

or die (mysql_error());

 

here

 

 

mysql_query($query) or die (mysql_error());

[nicholasolsen]

I figured out what the problem was.

It was a variable that didnt recieve its value on a different page, and therefore the value didnt show up in the mysql table..

 

Thanks for the reply fife.