Delete from DB?

[cooldude832]

I'm gonna sound stupid here, but

 

Can you delete all instances from a database where a UserID = $userid?

 

 

not just a table the whole db?

 

 

I'm developing something new and I wanted to know if it works and if I can combo it with innoDB to make it even better

 

[dropfaith]

so you want to delete a user from all tables in a database?

 

so it would remove the account ad all posts maid emails or whatever data your dealing with?

 

hrmm i havent seen anything to that extent

 

maybe loop an array as the table

 

<?
// includes
include("../header.php");


// open database connection
$conn = mysql_connect(HOST, DBUSER, PASS) or  die('Could not connect !<br />Please contact the site\'s administrator.');
$db = mysql_select_db(DB) or  die('Could not connect to database !<br />Please contact the site\'s administrator.');

// generate and execute query
$UserID = mysql_escape_string(trim(htmlentities($_GET['UserID'])));

$table = 

newmysql_query("DELETE FROM $table WHERE UserID = '$UserID'") 
or die(mysql_error()); 
echo newmysql_query;


echo mysql_query;
?>

[corbin]

You would have to do foreign keys or what dropfaith said.  There's no such thing as a DELETE FROM DATABASE statement ;p.

[cooldude832]

i was trying to get fancy with innoDB, but I realized that innoDB does this for me so I solved my own issue using the right engine.

 

its just innoDB is so constricting that if I don't need it I shouldn't use it

[corbin]

Constricting?  How is InnoDB constricting?

[cooldude832]

Constricting?  How is InnoDB constricting?

 

 

You lose some things you use to in ISAM

[corbin]

There are reasons for InnoDB over MyISAM though.  Row level locking, transactions....