DELETE FROM EXISTS ISSUE

[brandon000]

Buddy ol' Pals...please tell me why the following delete statement doesn't work.  I keep getting "Query was empty".  When I run the SQL with the "Select" statement just to verify any results and it works fine but when I set it to DELETE it doesn't work at all. ???

 

if ((isset($_GET['Delete_ProductID'])) && ($_GET['Delete_ProductID'] != "")) {

$DeleteProductID=$_GET['Delete_ProductID'];	

mysql_query("DELETE FROM product_sizes as p WHERE Exists (Select StyleID From product_styles as m Where m.ProductID=".$DeleteProductID." and p.StyleID=m.StyleID)");

}

[craygo]

Won't work. Something about deleting a row you are currently searching.

 

http://bugs.mysql.com/bug.php?id=5123

 

Ray

[brandon000]

Thanks for replying Craygo.  I guess it's a limitation with current MySQL.

 

What alternative do you recommend to achieve the DELETE statement to emmulate the EXISTS clause?

[craygo]

Well you can query first then run the delete

 

$check = "SELECT StyleID FROM product_styles WHERE ProductID = '$DeleteProductID'";
$ch_res = mysql_query($check) or die(mysql_error());
$found = mysql_num_rows($ch_res);
if($found > 0){
$row = mysql_fetch_assoc($ch_res);
$styleid = $row['StyleID'];
$delete = "DELETE FROM product_sizes WHERE StyleID = '$styleid'";
mysql_query($delete) or die(mysql_error());

 

Hope I interpolated that correctly.

 

Ray

[brandon000]

Excellent!  Thanks Ray