Question about changing certain data in MySQL database

[echoindia756]

Hi there,

 

I'm designing an online game website. I'm having a little trouble getting something to work right. You see players of the game can buy "credits", these allow them to buy things to further their rank etc and make them stronger than other players. But the problem i'm having is that when a player buys credits, it gives that player credits, but it also gives every other player in the database credits! So if one person buys 100 credits, every user in the database gets 100 credits.

This is the code i'm using:

 

mysql_query("UPDATE `game_planets` SET `belcredits`=`belcredits`+'100'");

 

How would I change that code so it only updates the person's credits who actually bought them? I was thinking of something like getting the username that the user used to login, or maybe somebody can think of a better way to solve this. Thanks in advance!

 

[Juan Dela Cruz]

your update query will update all the records in your belcredits because you dont have any condition "where clause" that says what record to be updated

[echoindia756]

your update query will update all the records in your belcredits because you dont have any condition "where clause" that says what record to be updated

 

I tried a few Where Clause's, but what clause would I write so that it only updated the users credits that actually bought the credits?

[ryeman98]

mysql_query("UPDATE `game_planets` SET `belcredits=belcredits+100");

[echoindia756]

mysql_query("UPDATE `game_planets` SET `belcredits=belcredits+100");

 

That doesn't have any where clause?? lol

[ryeman98]

mysql_query("UPDATE `game_planets` SET `belcredits=belcredits+100");

 

That doesn't have any where clause?? lol

 

Put one in, I don't know what your table looks like

[echoindia756]

Is there no way I can tell the code to only update the person's belcredits who bought the credits?

[ryeman98]

Is there no way I can tell the code to only update the person's belcredits who bought the credits?

 

Are you serious?

 

Get their ID or username or w/e and create a WHERE

[echoindia756]

Yea, that would be the logical thing - but how do I get the user id, I mean, I know you use the SELECT command to get things but how do I tell the code to identify the current user and match it up with the data in the username's field? If I could do that, that would solve the problem!

 

[DarkWater]

You don't store the user ID in the session?

[DarkerAngel]

mysql_query("UPDATE `game_planets` SET `belcredits`=`belcredits`+100 WHERE `username`='username' LIMIT 1");

 

There is an example of how it would update only one record based on username being usersname

 

though I highly suggest using an ID field and ID being a UNIQUE.

[echoindia756]

mysql_query("UPDATE `game_planets` SET `belcredits`=`belcredits`+100 WHERE `username`='username' LIMIT 1");

 

There is an example of how it would update only one record based on username being usersname

 

though I highly suggest using an ID field and ID being a UNIQUE.

 

Thanks! I have an ID Field in the database called id_owner and another field with the name of the planet. So would this work?

 

mysql_query("UPDATE `game_planets` SET `belcredits`=`belcredits`+100 WHERE `name`='id_owner' LIMIT 1");

 

 

[DarkerAngel]

you have it backwards

 

if the field is called `id_owner`

 

it would be WHERE `id_owner`='[however you have your data set]'

[echoindia756]

Ok, so when you say "=" does that mean that for example 1=1 or does it mean that they are in the same row of data? I'm just slightly confused! Thanks!

[echoindia756]

You know how you said:

 

it would be WHERE `id_owner`='[however you have your data set]'

 

in the "however you have your data set", what exactly goes there? Another table? e.g

`game_planets.id_owner`='game_planets.name' LIMIT 1");

                  This is puzzling me!

[echoindia756]

bump

[echoindia756]

Hi guys,

 

Does anybody have any ideas? How about if I tried something with

$_SESSION

? Would that work?

 

For example, could I put

WHERE game_planets.id_owner = $_SESSION['userid'] 

?

[echoindia756]

Please! Can anyone help me out?