$result = mysql_query("UPDATE tablename SET field='$field'") or die(mysql_error());I'm curious as to how I could have multiple rows at once, and then edit them all all at one time. Let's use a user database as an example. Right now, I just print out every single user with a link as their name which takes me to their own page. I'd like to be able to edit the page in which they all print out.
Username: [ yarub ] Password: [ **** ] Email: [ email@example.com ]
Username: [ fred ] Password: [ **** ] Email: [ firstname.lastname@example.org ]
Username: [ john ] Password: [ **** ] Email: [ email@example.com ]
[ update ]
The brackets represent input fields obviously. Can someone run me through the process of making this work? I have absolutely no idea and can't find any tutorials on it.
EDIT: Solved! Got some help from someone. Thanks to those who attempted to help me.