in reply to Re: Problem updating mysql table
in thread Problem updating mysql table

I have now, but I get the very same results, it only updates the first entry in the table, instead of them all. Anyway, I guess your way of writing the query is better than mine, so thanks for pointing it out!

Replies are listed 'Best First'.
Re^3: Problem updating mysql table
by Corion (Patriarch) on Dec 28, 2010 at 15:24 UTC

    How do you check that it only updates the first row? Are you sure your variables you put into the where clause contain what they should? Are you sure your database table contains the values it should?

      I check the mysql table and only the first row is updated. I'm pretty sure the variables in the where clause contains the right values since I print an html table that copy all the values that should be updated in the table, and those are fine, but they don't get updated into the actual mysql table