delete data from two tables at the same time...

[vyon13]

cn anyone help me.. this is my query in delting data from to two tables at the same time..

$query = DELETE FROM tblpost AND tblreply WHERE post_id = $_GET['id'];

hope you can help me.. thanks!!!

[rpnew]

cn anyone help me.. this is my query in delting data from to two tables at the same time..

$query = DELETE FROM tblpost AND tblreply WHERE post_id = $_GET['id'];

hope you can help me.. thanks!!!

hi,
You can use something like this........
[CODE=mysql]
delete f,s from tblpost f , tblreply s where f.post_id='cond ition' and s.post_id='cond ition';
[/CODE]

I'm not sure about the where condition clause.... you can check it on google....

Regards,
RP

[ifedi]

cn anyone help me.. this is my query in delting data from to two tables at the same time..

$query = DELETE FROM tblpost AND tblreply WHERE post_id = $_GET['id'];

hope you can help me.. thanks!!!

Why do you want to squeeze two sql statements into one, anyway?
You could make sequential delete statements, using a delimiter (usually as semicolon) like so:

$sql="DELETE from tblpost WHERE id= $_GET['id']; DELETE from tblreply WHERE id=$_GET['id']";
...

alternatively:

$sql = "DELETE from tblpost WHERE id = $_GET['id']";
$sql .= "DELETE from tblreply WHERE id = $_GET['id']";

Regards,
Ifedi.

[vyon13]

Why do you want to squeeze two sql statements into one, anyway?
You could make sequential delete statements, using a delimiter (usually as semicolon) like so:

$sql="DELETE from tblpost WHERE id= $_GET['id']; DELETE from tblreply WHERE id=$_GET['id']";
...

alternatively:

$sql = "DELETE from tblpost WHERE id = $_GET['id']";
$sql .= "DELETE from tblreply WHERE id = $_GET['id']";

Regards,
Ifedi.

thanks all!! GOD Bless..