Showing changes to tables

adam525 · Joined: 15 Feb 2008 Posts: 1

I'm working on an application that someone else wrote (using PHP and MySQL).

There are LOTS of queries that make changes to different tables with joins and it's really hard to track down what's been done to the data after running the code.

I've been trying to check some of the changes with mysql_affected_rows (for updates) and I've tried that function every way I can think of and I can't get that function to work.

I resorted to using a counter and just counting the number of times that a while loop runs to sort of get an idea of how many records _might_ have been touched.

That has (obviously) turned out to be unreliable.

Does anyone know of a tool (or method) to show changes to a mysql DB after running a query? I looked at mysql diff, but it just looks at structure changes. I need to know how many records were touched when this code was run and I've been working on this for quite sometime and I'm not getting anywhere.

Does anyone have any ideas?

Thanks very much in advance,

Adam

lostboy · Joined: 02 May 2004 Posts: 5128 Location: toronto, canada

if all the sql runs thru a common function perhaps you could add some code to write the sql to a file
_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google