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? Jeff Oien -- 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]