On Monday 04 November 2002 10:47, Leif K-Brooks wrote: > I keep forgetting where clauses. It's my dumbest mistake, and I always > make it. I just lost the password of everyone on my site trying to > change my own - not good. Anyway, I'm trying to edit PhpMyAdmin to warn > if there's more than a certain number of affected rows for a query. Is > there a way to tell number of affected rows before executing the query? AFAIK there isn't. What you can do are: 1) Get into the habit of writing WHERE clauses. 2) Write SELECT queries instead, once you're sure you've got it right change it to a DELETE query. 3) Backup your database/tables before doing anything drastic. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Art is a jealous mistress. -- Ralph Waldo Emerson */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
