Re: Problem updating mysql table

You should use placeholders:

        $update = qq{UPDATE inst_3 SET u1=? WHERE object=?";
        $sthinstance = $dbhinstance->prepare($update);
        $rvinstance = $sthinstance ->execute( $toupdt, $curent );
[download]

Comment on Re: Problem updating mysql table Download Code

Replies are listed 'Best First'.
Re^2: Problem updating mysql table by remluvr (Sexton) on Dec 28, 2010 at 15:16 UTC
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!	[reply]
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?	[reply] [d/l]
Re^4: Problem updating mysql table by remluvr (Sexton) on Dec 28, 2010 at 15:56 UTC
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	[reply] [d/l]