 |  |  |  |  |  |  |  |
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
301 advanced apache api array autosuggest basics beginner broken cakephp class cms code combobox compression cron curl data database date datepart display dropdownlist dynamic email eregi error execution file files folder form forms function functions google head href htaccess html httppost if...loop image include includingmysecondfileinthechain ip javascript job joomla jquery js key library limit link login md5 menu mlm multiple mysql mysql_real_escape_string oop password paypal pdf pdfdownload php phpvotingscript problem procedure query random screen script search searchbox server session sessions smarty source space sql stored system table traffic tutorial unicode upload url variable video volume votedown web website youtube zend