two delete function

[xxreenaxx1]

How can you make these two delete function as one.

 

DELETE 
FROM test
WHERE 
Tes_ID= 11;


DELETE
FROM question
WHERE
Tes_ID=11;

[techdude]

  Quote

DELETE

FROM test, question

WHERE

Tes_ID= 11;

 

Post back if this helped. (Also, read the guidelines before posting.)

 

--

techdude

[xxreenaxx1]

Nope. I tired few other ways as well. Nothing works.

 

This is the error message I am getting

  Quote

Cannot Execute:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Tes_ID=11' at line 3

 

I am using function for this method. And on line 3 I have

 

function comple($Test_ID){

[techdude]

Ooops! Sorry, I got the syntax incorrect. Try this instead:

  Quote

DELETE t, q

FROM test t, question q

WHERE t.Tes_ID = q.Tes_ID

AND t.Tes_ID = 27;

 

Post back if this helped.

 

--

techdude

[xxreenaxx1]

It worked. Thank you

[techdude]

Glad I can help

 

--

techdude