 |  |  |  |  |  |  |  |
Getting mysql "UNaffected" rows
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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 ?
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 ?
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) GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.
|
Similar Threads
- updating multiple rows with one form (PHP)
- "Must visit from" javascript wont work in IE... (JavaScript / DHTML / AJAX)
- Who's Online "My Thread" Indication (DaniWeb Community Feedback)
- javascript works in IE but not working in firefox (JavaScript / DHTML / AJAX)
- it's simple but yet complicated...php and mysql search.. (PHP)
- while function and "mysql_fetch_assoc() not a valid MySQL result resource" (PHP)
- Rows not added correctly when using 'INSERT' (PHP)
Other Threads in the PHP Forum
- Previous Thread: How to disable brouser back.
- Next Thread: Paging Problem
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
# 5.2.10 alexa apache api array beginner binary broken cakephp checkbox class clean clients cms code cron curl database date directory display dissertation dropdown dynamic echo echo$_get[x]changingitintovariable... email encode error fairness file files folder form forms function functions google href htaccess html image images include indentedsubcategory insert ip javascript joomla legislation limit link local login mail memberships menu mlm multiple multipletables mysql mysqlquery newsletters oop open paypal pdf persist php problem provider query radio random recursion remote rss script search server sessions sms sockets source space spam sql syntax system table tutorial update upload url validator variable video web youtube
