[SOLVED] DELETE question

[182x]

Hey guys,

 

I am going to write a php script to delete some records based on values supplies by the user. I was just wondering if the query is correct but there are no records to delete for example if this query was executed but there was no testId 7, would an error occur or would the query be performed but just not delete any records?

 

Thanks. (not at a testing machine at the mo or would test this out myself)

 

$testId = 7;
$q="DELETE  FROM test WHERE testId = $testId";
mysql_query($q, $link_id)or die(mysql_error());

 

Edit: Error in code my bad.

[AndyB]

If the query is valid (regardless of how many results it returns) you will not get an error.  Your example query is not valid. See http://www.tizag.com/mysqlTutorial/mysqldelete.php

[182x]

Thanks for pointing that out. So just to be clear if the above code was now executed and there was no testId equal to 7, its still ok? thanks.

[AndyB]

Yes.

[182x]

Thank you.