Deleting records from two tables

[PRodgers4284]

Im want to delete records from two tables, the tables are called "employers" and "job". I am want to delete records based on the username in each table.

 

Im using the following query but im not sure if the syntax is correct for deleting from two tables:

 

 

mysql_query("DELETE FROM employers && job WHERE username='$username'");

 

Can anyone help?

[Barand]

DELETE FROM employers e , job j

WHERE e.username = j.username

AND e.username = '$username'

[PRodgers4284]

Hey thanks for the reply, i tried the query you suggested, but it doesnt same to be deleting the records, below is the php code I have now:

 

<?php  
$username = $_GET['username'];

if (isset($_POST['submit'])) { 


   mysql_query("DELETE FROM employers e , job j WHERE e.username = j.username AND e.username = '$username'"); 
  


?>  
           
<br /> 
<a href="Indexadmin.php">Back to main page</a> 
<br /> 
<br /> 
<br /> 
The Employer account for <b><?php echo $username; ?></b> has been deleted from the system 
<?php  
}  
else  
{  

$account = mysql_fetch_array(mysql_query("SELECT * FROM employers WHERE username='$username'")); 

?>  

[Barand]

One question comes to mind

 

If you are POSTing data, why is username coming from GET