Deleting rows from mysql database

Question

I have a problem deleting rows from table with parameters. Here is the code:

if ($dbProductImageIdNumber) { $ImagesToDeleteNumber = $dbProductImageIdNumber -1 - $numItemImages; echo "$dbProductImageIdNumber" . ' '; echo "$numItemImages" . ' '; echo "$ImagesToDeleteNumber" . ' '; echo 'Deleting'; mysql_query("DELETE FROM wp_posts WHERE post_parent = '$dbProductId' ,ID != '$dbProductThumbnail'"); }

Problem is that != seems to be understood wrongly, maybe I'm dooing syntax mistakes?

Will apreciate any help.

-----EDIT-----

Ok, here what I have now:

if ($dbProductImageIdNumber) { $ImagesToDeleteNumber = $dbProductImageIdNumber -1 - $numItemImages; echo "$dbProductImageIdNumber" . ' '; echo "$numItemImages" . ' '; echo "$ImagesToDeleteNumber" . ' '; echo "$dbProductId" . ' '; echo "$dbProductThumbnail" . ' '; mysql_query("DELETE FROM wp_posts WHERE post_parent = '$dbProductId' AND ID != '$dbProductThumbnail'"); }

Example: my $dbProductId is '16' and $dbProductThumbnail '17'. Qestion is, why this command do not delete any row where post_parent is '16' and ID isn't 17? Any leads?

Community · Accepted Answer · 2017-05-23 11:43:21Z

it should be AND and not comma.

DELETE FROM wp_posts WHERE post_parent = '$dbProductId' AND ID != '$dbProductThumbnail'

As a sidenote, the query is vulnerable with SQL Injection if the value(s) of the variables came from the outside. Please take a look at the article below to learn how to prevent from it. By using PreparedStatements you can get rid of using single quotes around values.

How to prevent SQL injection in PHP?

Jwalin Shah · Accepted Answer · 2013-02-28 09:53:08Z

0

Problem is not != but the problem was that you have used "," instead of AND in your code between post_parent = '$dbProductId' ,ID != '$dbProductThumbnail'"

mysql_query("DELETE FROM wp_posts WHERE post_parent = '$dbProductId' ,ID != '$dbProductThumbnail'"); }

So, corrent syntax is below.

DELETE FROM wp_posts WHERE post_parent = '$dbProductId' AND ID != '$dbProductThumbnail'

answered Feb 28, 2013 at 9:53

Jwalin Shah

2,5311 gold badge19 silver badges22 bronze badges

4 Comments

Kazik Jarmolovski Over a year ago

Updated my post, please look there. AND was a mistake, but it didn't help.

Jwalin Shah Over a year ago

DELETE FROM wp_posts WHERE post_parent = '$dbProductId' AND ID <> '$dbProductThumbnail'

Kazik Jarmolovski Over a year ago

With <> it deletes everything even a row where ID is $dbProductThumbnail.

Kazik Jarmolovski Over a year ago

Oh, that was my mistake.. $dbProductThumbnail was empty. So now it works! :) Thank you very much! It seems all these answers were rigth then, but I suppose I will mark yours as you helped me the most, and as I can see you need rep points the most too. :)

Sumit Bijvani · Accepted Answer · 2013-02-28 09:22:10Z

0

Use AND or OR in your WHERE statement

DELETE FROM wp_posts WHERE post_parent = '$dbProductId' AND ID != '$dbProductThumbnail'

answered Feb 28, 2013 at 9:22

Sumit Bijvani

8,17518 gold badges52 silver badges83 bronze badges

1 Comment

Kazik Jarmolovski Over a year ago

Updated my post, please look there. AND was a mistake, but it didn't help.

Collectives™ on Stack Overflow

Deleting rows from mysql database

3 Answers 3

Comments

4 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

1 Comment

Linked

Related