E-mail copy of MySQL update query to self

Text backup of changes made to MySQL table

[s9901470]

Hi

I would like to have an e-mailed copy of the data which my visitors update a MySQL database with.

The existing code is below. I would like to add something underneath along the lines off 'Email a list of all the values q201-q204 to [e-mail] in comma separated format'. This is just so I can keep an eye on what visitors are doing without having to check the mysql table manually.

Any suggestions? Thank you in advance.

mysql_select_db('quiz');
$query = "UPDATE quiz SET
stamp_i=NOW(),
q201='".$q201."',
q202='".$q202."',
q203='".$q203."',
q204='".$q204."' WHERE uname='".$uname."' ";

[lobo235]

You could easily mail the query string to yourself which will tell you exactly what got inserted. Just do something like:

mail( '[e-mail]', 'Insert Query', $query );

This would send an email to [e-mail] with the subject 'Insert Query' and the body of the message would be everything in the $query variable.

[s9901470]

That works great! Many thanks.