Issue with this function. The code is not executing.
        Posted  
        
            by Tapha
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Tapha
        
        
        
        Published on 2010-03-15T21:14:02Z
        Indexed on 
            2010/03/15
            21:19 UTC
        
        
        Read the original article
        Hit count: 185
        
php
The function is supposed to update the values in the database.
Here is the code:
//Functions
//Function to Update users networth
function update_net($name)
    {
    //Get worth & balance at the time
    $sql_to_get_worth_balance = "SELECT * FROM user WHERE username = '$name'";
    $sql_query = mysql_query($sql_to_get_worth_balance);
    while ($rows = mysql_fetch_assoc($sql_query))
    {
     $worth = $rows['worth'];
     $balance_ = $rows['cash_balance'];
    }
    //Get net_worth  now
    $new_net_worth = $worth + $balance;
    //Update net_worth
    $sql_for_new_worth = "UPDATE user SET net_worth = '$new_net_worth'";
    $sql_worth_query = mysql_query($sql_worth);
    }
It is used here:
//Get username
$username = $_SESSION['username'];
if (isset($username))
{
  //Update networth
  $update_worth = update_net($username);
© Stack Overflow or respective owner