MySql

[McJedi]

How can I update one square of MySql, and not effect the rest..so:

User               Pass               Email          Website                   Logins
Joe                  hi               blah             none                        1
Sue                 bye               blah2           google                       1
Lisa                boo               blah3            none                       1

When Lisa logs in again how can I change her 1 to a 2, without effecting any other rows or columns? And this forum made the example table look like crap so I guess you have to imagine it -_-

[manavo11]

Adding the code tags around the table will make the table look like what you want (I did it for you).

[oceanebelle]

How can I update one square of MySql, and not effect the rest..so:

User               Pass               Email          Website                   Logins
Joe                  hi               blah             none                        1
Sue                 bye               blah2           google                       1
Lisa                boo               blah3            none                       1

When Lisa logs in again how can I change her 1 to a 2, without effecting any other rows or columns? And this forum made the example table look like crap so I guess you have to imagine it -_-

one square??? I'm not so sure... i assume this is a tablename
so

update tablename set Logins = 2 where User = 'Lisa'

they shouldn't be any different right?
BTW, don't have mysql here... but that's basic sql... it should work

[Anita101g]

???
Stab in the dark here

$user = $_SESSION["user"];
UPDATE [TABLENAME] SELECT User where user = '$user' set Logins 2 

[oceanebelle]

can't simple sql statements do?

[oceanebelle]

and btw anita.. I have not encountered syntax like that before.

[christoph]

$query = "UPDATE tablename SET Logins ='2' WHERE User ='Lisa' LIMIT 1 ";

mysql_query($query)
 or die ("Could not insert data because ".mysql_error()); 

That'll work.

-chris

[Anita101g]

i was basically doing what Christoph was doing

i think Simple SQL statements only apply in VB

[Pc_Madness]

UPDATE MyTable SET Logins = Logins + 1 WHERE User = Lisa


Yeah, THATS RIGHT, PWNED YOU ALL!

Sorry

Edit: And although it could be that your table is just an example, but make sure you store passwords as MD5 hashes, not the raw password.

[nkad]

Edit: And although it could be that your table is just an example, but make sure you store passwords as MD5 hashes, not the raw password.

Well, that's debatable. If I didn't need to retrieve the plan-text password as some future point in time, I would use SHA to generate the hash, (because MD5 has a more likely chance of causing collisions). If I want to store the password in a secure way so that I can retrieve it later, I would use DES or ASE encryption.

[techgnome]

Why would you need to retrieve the plain text password?

Tg

[oceanebelle]

i was basically doing what Christoph was doing

i think Simple SQL statements only apply in VB

???

[visualAd]

Well, that's debatable. If I didn't need to retrieve the plan-text password as some future point in time, I would use SHA to generate the hash, (because MD5 has a more likely chance of causing collisions). If I want to store the password in a secure way so that I can retrieve it later, I would use DES or ASE encryption.

Collisions? - MD5 is a good way too protect passwords, it takes ages and a lot of processing power to find a string which produces a particular hash, even then there is no guarantee that it is the password, because like you said , some strings produce identical hashes.

Hashing the password doesn't protect the user from having their account hacked or the hash snooped while it is being transferred over the network, but it does protect the identity of the password.