javalopes

dont show any error just dont update the fields

i have made this code but still not working some 1 can see whats wrong? // ----------------------------------- REFERALS --------------------------------- // Get refered $query = ("UPDATE user SET referalsearns=referalsearns+".$referalsearns. " WHERE refered='" .$refered. "'"); mysql_query($query) or die('Query "' . $query . '" failed: ' . mysql_error()); // Update Balance $query = ("UPDATE user SET balance=balance+".$currency. " WHERE username='" .$username. "'"); mysql_query($query) or die('Query "' . $query . '" failed: ' . mysql_error());

the users cant change the username. and i alredy try it alot but no luckim too noob on php im sory if im hasking too mutch

Hi guys. Im starting an online webpage. I recently have some sql/php doubts. I need the php-sql code for this situation: - Table: users - balance - refered - (person who refered the current logged in user - aka "referals") - username. When certain user do an action. The sql should see his/her refered person. Then when the user get the usally +balance for doing an action his/her refered should be credited to. User -> Action -> User balance = balance + (x) -> refered balance + (y). I enter an following img atachment to explain it. Very gratefull for your time/help