Getting mysql "UNaffected" rows

Expand Post »

Hi,

My php script would do a few updates/inserts to a table. after that I would like the rows that have not been affected by the script to be deleted from the database.

cant figure out how to do this.

any ideas ?

Similar Threads

updating multiple rows with one form in PHP
"Must visit from" javascript wont work in IE... in JavaScript / DHTML / AJAX
Who's Online "My Thread" Indication in DaniWeb Community Feedback
javascript works in IE but not working in firefox in JavaScript / DHTML / AJAX
it's simple but yet complicated...php and mysql search.. in PHP

roy--

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

25 posts
since Sep 2007

Permalink

Oct 8th, 2007

Re: Getting mysql "UNaffected" rows

Well if you are using a condition to select the rows to be inserted/updated just reverse the condition and do a delete on those so if you have something like WHERE name = "bob" just do WHERE name != "bob" aside from reversing a condition I'm not sure there is a way of getting the unaffected rows (hopefully I will be corrected on this)

ShawnCplus

Sponsor

Reputation Points: 520

Solved Threads: 268

Code Monkey

Offline

1,564 posts
since Apr 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: How to disable brouser back.

Next Thread in PHP Forum Timeline: Paging Problem

DaniWeb Message

Cancel Changes

User Name
Password