How to delete/remove a specific table row in mySQL using php?

Question

I already have this code:

<?php
if ($quantity == 0){
$prd_name = " ";
$colors = " ";
$sizes = " ";
$quantity = " ";
$price = " ";
$TIP = " ";
$TPA = " ";
$cost = " ";
$amount = " ";
$query ="DELETE FROM orders WHERE quantity='0'";
}
?>

But it still makes a table row entry.

What I am trying to do is when the inputed number of quantity is 0 then the table row will be deleted. Please bear with me for I'm new in php and mySQL coding.

just assigning some sql-looking text to a variable doesn't actually DO anything. you still need to execute that query, which means loading up a DB library. Try php.net/pdo or php.net/mysqli — Marc B
– Marc B, Commented Jul 31, 2012 at 5:38

Dr. Dan · Accepted Answer · 2012-07-31 05:39:15Z

1

You forgot to execute the query. It should be

$query = mysql_query("DELETE FROM orders WHERE quantity='0'");

answered Jul 31, 2012 at 5:39

Dr. Dan

2,28816 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mrsrinivas · Accepted Answer · 2012-07-31 05:55:40Z

0

Once run the query by removing Quotes to 0 If it's a number

<?php
    if($quantity==0)
     {
       $query = "DELETE FROM orders WHERE quantity = 0 ";
       mysql_query($query);
      }
 ?>

answered Jul 31, 2012 at 5:55

mrsrinivas

35.7k13 gold badges133 silver badges132 bronze badges

2 Comments

Ruri Over a year ago

thanks. it works now. however, the previous quantity number is still reflected on the table.

mrsrinivas Over a year ago

@Ruri: I'm glad that I was able to help.

Shee · Accepted Answer · 2012-07-31 06:21:12Z

0

<?php
    if($quantity==0)
     {
       $query="Delete from orders where quantity=0";
       mysql_query($query);
      }
 ?>

edited Jul 31, 2012 at 6:21

answered Jul 31, 2012 at 5:50

Shee

1,9452 gold badges14 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to delete/remove a specific table row in mySQL using php?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related