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 ?
roy--
0
Light Poster
ShawnCplus
456
Code Monkey
Team Colleague
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)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.