How can I combine these queries?

[advancedfuture]

Happy Holidays Fellow PHPFreaks!

 

I wanted to know how can I combine these two queries, if possible at all.

 

$query = "UPDATE users SET active='n' WHERE username='$payer_email'";
mysql_query($query);

$query = "DELETE FROM services WHERE username='$payer_email'";
mysql_query($query);

[trq]

mysql_query() can only handle one query at a time so executing these as separate queries is the best you can do I'm afraid.

[PFMaBiSmAd]

And since you would want to check in your application code if the UPDATE query is successful before you execute the DELETE query, you would not necessarily want to ever combine them.