in reply to Re: Mysql update table problem
in thread Mysql update table problem

I still can't find where the problem lies. I select the right fields with my first query, I copy the data into the right table with the second query. What I need to do then, is update the first table (using two specific columns), so that the data that are already used won't be used no more. For every selected data, I have to update the column "assigned" and the column "evaluated" with a number, obviously just for data that are selcted by the first query. I don't know how to do it. I tried what you suggested but with no success.

Replies are listed 'Best First'.
Re^3: Mysql update table problem
by samarzone (Pilgrim) on Nov 10, 2010 at 06:59 UTC

    Check for the return value of "execute". If transaction is successful it should return the number of affected rows. Otherwise it will set the variable $DBI::errstr.

    Also have a look at "RaiseError"

    Do post what you have done and what you got.

      Thanks, I finally got around it and now it works.