Deleting stuff

[Danny620]

Hi, Sorry to bother you all like this but I really good do with some help.

 

My problem is I have 3 tables users, case_ref & updates all realated to each other by a user_id - I want to be able to delete from all tables if the users account is deleted.

So if a user is deleted so is all the associated data too.

 

delete from users, case_ref, updates where user_id = 1

 

I would be extremely great full if you could help me out on this one.

[Maq]

Have a look in the manual, Multiple-table syntax:

http://dev.mysql.com/doc/refman/5.0/en/delete.html

 

 

[Danny620]

sorry can u help me

[Maq]

What are you having trouble with specifically?

[Danny620]

I just want a query that allows me to delete all records when the user is deleted like DELETE FROM users, case_ref, updates WHERE user_id='9' however this does'tn seem to work in php.

 

Please help me.

[Maq]

Did you look at the link I sent you?  It shows you exactly how to do it.  Does your query throw and error?  What happens?  Can you post the current query you have?

[Danny620]

ive add to do 3

 

// Make the query:
	$q = "DELETE FROM case_ref WHERE user_id='$id'";		
	$r = $r = mysqli_query ($dbc, $q);

	// Make the query:
	$q = "DELETE FROM case_ref WHERE user_id='$id'";		
	$r = $r = mysqli_query ($dbc, $q);

	// Make the query:
	$q = "DELETE FROM users WHERE user_id='$id'";		
	$r = $r = mysqli_query ($dbc, $q);