I have this which inserts a stock trade entry:
$sql1 = "INSERT INTO $table_name
(stock, shares, LorS, type, price1, time1) VALUES
(\"$stock\", \"$shares\", \"$LorS\", \"$type\", \"$price1\", NOW())";
With price1 being the entry price and time1 the date/time of entry.
Then when I exit the trade it will do this:
$sql1 = "update $table_name set stock = '$stock',
shares = '$shares', LorS = '$LorS', type = '$type',
price1 = '$price1', price2 = '$price2', time2 = NOW() where id = '$id'";
However, time1 is being updated to be the same as time2 after
the exit and I don't want it to be. Am I missing something?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]