Some php help if you guys dont mind

[javalopes]

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













 

[cpd]

What happens if the user changes their username? If username is unique and will never change, why don't you use it as the primary key?

 

What have you attempted yourself? We're not about to write the code for you which is why your post implies you think?

Edited June 4, 2013 by cpd

[javalopes]

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

[cpd]

Show us what you have and lets try and address your problems. No-one is going to write the code for you so forget about it.

[Jessica]

Best practice is to use an auto-incrementing id as your primary key, even if you think usernames will never change.

 

OP: You haven't posted a question or a problem or any code. You've just posted what you want to happen. Cool story.

[javalopes]

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());

[Jessica]

 

What did the error say?

[javalopes]

dont show any error just dont update the fields

[DaveyK]

Are you sure the queries run in the first place?

 

Try echoing something or perhaps (for development):

$q= mysql_query($query);

if ($q!== false)
{
  echo 'query was succesful';
}
else
{
  die('Query "' . $q. '" failed: ' . mysql_error())
}

the difference between what you do and what I describe above is that you always get a confirmation that the query actually did something. In your case, if you dont see an error you just assume that the query ran. Perhaps it doesnt even go that far in your script because of a previous error.

 

Also:

echo mysql_affected_rows(); // This will tell you how many rows were affected, or updated in this case.

Edited June 5, 2013 by DaveyK