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: 158

Filed under:

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

Related posts about php