Will this do whay I want?

tommmmm

Will this code loop through the array and delete everything from each of the tables for a particular user.

$tables = array (
"user",
"user_info",
"foo",
"bar"
);
foreach ($tables as $value) {
DELETE * FROM $value WHERE user=$username
echo 'user deleted from '.$value;
}

Also is there a better way to delete all user info across multiple tables? This seems as if it could be quite inefficient.

redrage

you don't need the *

mysql_query("DELETE FROM $tblname where user='$user'");

tommmmm

Cool cool. Thanks a bunch, it was mainly the foreach I wanted to check, never done any work with arrays before really.

redrage

ya the foreach looks like it "should" work.

just realized a better way though

mysql_query("DELETE FROM table1,table2,table3 where user='$user'");

no looping required. Never used it but "I think" it should work. just seperate tables by a comma.

tommmmm

Would that be a more efficenet method for doing that? Seems they would both do exactly the same thing but the loop/array might be less efficent/more memory hogging.

jdorsch

tommmmm wrote:
Would that be a more efficenet method for doing that? Seems they would both do exactly the same thing but the loop/array might be less efficent/more memory hogging.

4 delete queries is not memory hogging whether or not its in a loop. Yeah it might take a little memory, but you are not going to tell the difference unless this is on an enterprise system where you are getting 2000 hits a second or if you are running a loop on 800 users and deleting each one.