MySql

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

Code:

---

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 -_-

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

Quote:

---

Originally Posted by McJedi

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

Code:

---

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

Code:

---

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

???
Stab in the dark here

PHP Code:

---

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


---

can't simple sql statements do?

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

PHP Code:

---

$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

i was basically doing what Christoph was doing

i think Simple SQL statements only apply in VB

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


Yeah, THATS RIGHT, PWNED YOU ALL! :p

Sorry :p

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. :)

Quote:

---

Originally Posted by Pc_Madness

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.

Why would you need to retrieve the plain text password?

Tg

Quote:

---

Originally Posted by Anita101g

i was basically doing what Christoph was doing

i think Simple SQL statements only apply in VB

---

??? :ehh:

Quote:

---

Originally Posted by nkad

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.