Re^2: 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.

Comment on Re^2: Mysql update table problem

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.	[reply]
Re^4: Mysql update table problem by jb22 (Initiate) on Nov 10, 2010 at 15:51 UTC
Thanks, I finally got around it and now it works.	[reply]