[SOLVED] Query Help

[steviez]

Hi,

 

I have some sql code that executes when a user clicks a button:

 

$sql = "DELETE FROM user WHERE id = '$UsErId'";

 

The problem is that i need two or three more querys to be executed with the same button, how can this be done?

 

Any help would be great!

 

 

Steve

[artacus]

This has to be done from a php page so just run the query, then the next then the next.

 

Or if they are all related, you could join them and do the delete.

[steviez]

They are all to delete but from different bits (user, audio etc)

 

How do i do this?

 

Sorry for my lack of knowlage but im new to php

[artacus]

Well do you know how to join tables? If so, you can do it all in 1 query.

 

But just change your code:

$sql = "DELETE FROM user WHERE id = '$UsErId'";

$result = mysql_query($sql) or die(mysql_error());

$sql = "DELETE FROM audio WHERE userid = '$UsErId'";

$result = mysql_query($sql) or die(mysql_error());

$sql = "DELETE FROM photos WHERE userid = '$UsErId'";

$result = mysql_query($sql) or die(mysql_error());

[Democreous]

I'm new too, but I'm gonna give this a shot

 

your query $sql = "DELETE FROM user WHERE id = '$UsErId'";

deletes a single row right?

 

To delete multiple rows try

 

$sql = "DELETE FROM user,audio, etc WHERE id = '$UsErId'";

 

or if that doesn't work

 

$sql = "DELETE FROM user && audio && etc WHERE id = '$UsErId'";

 

 

that's my best shot