if ($_POST['buy'])
{
$myrow=mysql_fetch_array(mysql_query("SELECT * FROM users WHERE username='".$uname."'"));
$amount1 = $amount*$stockamt;
if ($myrow["aura"] < $amount1)
{
echo "<tr><td colspan=3 class=sys align=center>You don't have enough $aura to purchase ".$shares." share(s).</td></tr>";
}
else
{
$newaura = $myrow["aura"] - $amount1;
// update aura
mysql_query("UPDATE `users` SET `aura` = ".$newaura." WHERE `username` = '".$uname."'");
// actually add stocks
$stpg=mysql_fetch_array(mysql_query("SELECT * FROM `userstocks` WHERE `userid` = '".$u["userid"]."'"));
if ($stpg["amount"] == 0) {
mysql_query("INSERT INTO `userstocks` (`stockid`,`userid`,`amount`) VALUES ('".$stid."','".$u["userid"]."','1')");
mysql_query("INSERT INTO `userstocks2` (`stockid`,`userid`,`amount`) VALUES ('".$stid."','".$u["userid"]."','".$stockamt."')");
echo "<tr><td align=center colspan=3 class=sys>Your shares have been purchased.</td></tr>";
} else {
$prcamountnew=$stpg["amount"]+1;
mysql_query("UPDATE `userstocks2` SET `amount`='".$prcamountnew."' WHERE `userid` = '".$u["userid"]."'");
echo "<tr><td align=center colspan=3 class=sys>Your shares have been purchased.</td></tr>";
}
}
}
I want it to insert (which it does) when its the first time... then I just want it to update when they do it again (which it doesn't)
WHY!?
I'll check back tomorrow... kthnx
