Update Database
Posted on
16th Feb 2014 07:03 pm by
admin
Hi All,
I have a problem with this:
Code: [Select]<?php
session_start();
include('../common/dbconnect.php');
$stock_id = $_GET['stock_id'];
$query='SELECT * FROM users_stocks WHERE user_id ="' . $_SESSION['user_id'] . '"';
$result = mysql_query($query, $conn) or die(mysql_error($conn));
$row = mysql_fetch_array($result);
extract($row);
$query1="SELECT t_val FROM stocks WHERE stock_id = '$stock_id'";
$result1 = mysql_query($query1, $conn) or die(mysql_error($conn));
$rows = mysql_fetch_array($result1);
extract($rows);
$query2="SELECT quant FROM users_stocks_details WHERE stock_id = '$stock_id' AND user_id ='" . $_SESSION['user_id'] . "'";
$result2 = mysql_query($query2, $conn) or die(mysql_error($conn));
$rows2 = mysql_fetch_array($result2);
extract($rows2);
//the values
$t = $row['total'];
$b = $row['bank'];
$t_val=$rows['t_val'];
$q = $_GET['quantity'];
$quant =$rows2['quant'];
//sums
$newb = $q * $t_val + $b;
$newt = $t + $newb;
$newquant = $quant - $q;
//the interesting bit
if ($q == 0)
{
echo "You Dont Have Any Stocks To Sell!";
}
if ($q > 0)
{
$updatebank = "UPDATE users_stocks SET bank = $newb WHERE user_id ='" . $_SESSION['user_id'] . "'";
$updatetotal = "UPDATE users_stocks SET total = $newt WHERE user_id ='" . $_SESSION['user_id'] . "'";
$updatequant = "UPDATE users_stocks_details SET quant = $newquant WHERE stock_id = '$stock_id' AND user_id ='" .$_SESSION['user_id']."'";
$showresults = "SELECT * FROM users_stocks WHERE user_id ='" . $_SESSION['user_id'] . "'";
$results = mysql_query($showresults, $conn) or die(mysql_error($conn));
$rrows = mysql_fetch_array($results);
extract($rrows);
echo "Thank you! You have succesfully sold $q stocks and you bank balance has incresed to $$newb, you have $newquant of these stocks left
";
}
?>
The total and bank updates work as they should, however the quantity of stocks does not decrease! Anyone see anything obvious?
Thanks
No comments posted yet
Your Answer:
Login to answer
68
47
Other forums
Most basic form question ever?
Hello,
I want to use this snippet to make sure the fields in a form are ok before processing
Recognising Revenue daily
Hello.
Has anyone come across daily recognition of deferred income?
We want to implement R
Add trigger to UpdatePanel programmatically
Hi,I'm working on a website which uses AJAX and Masterpages. What I have is an AJAX UpdatePanel whi
Date Question
I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, ho
Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.
we have to suppl
Hom to make one url to open together with another url
I have a chat, which i want to be opened, as soon as the users login to the site. As it is now, when
HTAccess auto log in?
Hi all.
Too busy driving celebs about lately so I hope someone here can help me out.
I
single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be
Limiting uploaded file type
I am working on a simple upload script, and I need it to limit the allowed file type that is uploade
Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.