Page 1 of 1

query checking

Posted: Wed Mar 05, 2003 5:00 pm
by the
Is there a way to check if INSERT or UPDATE query was done.

Having a problem with a shoppingcart where only sometimes it doesn't update or iunsert the db with the customer and orders infos but I get the email confirmation with the right infos.
All the query are done on the same page at the top and mail() at the bottom.

Any idea.

Thanks

Re: query checking

Posted: Wed Mar 05, 2003 5:03 pm
by hedge
the wrote:Is there a way to check if INSERT or UPDATE query was done.

Having a problem with a shoppingcart where only sometimes it doesn't update or iunsert the db with the customer and orders infos but I get the email confirmation with the right infos.
All the query are done on the same page at the top and mail() at the bottom.

Any idea.

Thanks
what DB? some have auditing that you can use to track things like that.

Posted: Wed Mar 05, 2003 5:20 pm
by the
The db is mysql

Posted: Wed Mar 05, 2003 6:55 pm
by hedge
Sorry, I can't help then. My skills are more with Oracle.. There are a lot of MySQL experts here though, someone should know.

Posted: Thu Mar 06, 2003 2:19 am
by twigletmac
the wrote:Is there a way to check if INSERT or UPDATE query was done.
Try mysql_affected_rows().

Mac