clear database, but leave user info

[mforan]

hi there, how would i go about making a php script that resets all the information in the database to the default values?
this would exclude there username, email address etc....

is this at all possible?

[trq]

The easiest way would probably be to copy any data you want to keep into a temp table, drop the current table, then copy the saved data into a new table.

My question is Why?

[Zane]

explain a little more

what are the default values
which [b]information[/b] in the database

and most likely the answer to this is an SQL statement
not a PHP script, although you can use PHP to do it

[marcus]

You could just do

[code]
$sql = "UPDATE `users` SET `field1` =0, `field2` =0";
$res = mysql_query($sql) or die(mysql_error());
[/code]

[mforan]

well rather than remove all the user data i want to keep there username and password. the other material i can reset to 0 or to the default values.

basically its a game that resets every so oftern, and i dont want to remove there username information everytime i do this reset.

this is so that even after the reset the can log in to the same user, but everyone starts at a default level once more.
is that any help guys?

[marcus]

You can do that

by updating the rows

[code]
$sql = "UPDATE users SET `level` =1, `points` =250";
$res = mysql_query($sql) or die(mysql_error());
[/code]

[mforan]

is that just for 1? or the entire list...

[marcus]

that would be the entire list

[mforan]

thanks, this worked a treat!  ;D