MySQL security

[Anon]

I'm going to make a site where customers can log in and change their contact info etc.
I would want to do it in one table, one row per customer. But how can I secure it so that AA can't change BB's contact info?

Tnx!
Eric

[[deleted]]

use a username/password system. :-)

[Anon]

Yes, of course, but I don't know how to make ROWS in a db passwd-protected. I only know about securing dbs, tables and columns.
So can anybody help? Do I have to do it in php, or is there any better way?

Tnx
Eric

[[deleted]]

You can't secure rows in a database. Why would you ever want to?

All you have to do is make sure that the script you write can only update rows that contain information about the currently-loggedin user.

Something like
UPDATE table SET bla=bla WHERE id=$current_user_id;