Maybe it would be enough if you created a little syntax window on your GUI and an Execute button beside it, so you could see what was going to be sent to the engine before clicking Execute.
Just a thought, Arthur ----- Original Message ----- From: "Petre Agenbag" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 8:43 AM Subject: "dummy" queries + csv dump > Hi, > I would like to know if it is possible to run a "dummy" qury on a table, > check for the number of possibly affected rows, and then, according to > specific conditions, execute the query for real. > The reason why I ask this is as follow ( in case you can't do it, but > you have another suggestion); > I wrote a little generic table edit/view/browse utility in PHP and today > something horrible happened, when I changed an entry in a row, the > entire table was updated with that data, as if I had run an "update set > x=y" , yet, I assure you, I did have a "where id=$id" caluse in the sql. > That's why I would like to first run a dummy ( specially for update or > delete sql's ) and only if the affected rows are 1, should it execute > the query. > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
