Support » Plugins » Hacks » $wpdb question…

  • Does $wpdb need to be reset or unset somehow after a query is run?

    I hacked an existing plugin to include a rating/voting routine. The original plugin, using $wpdb, creates a list. I added icons that can be clicked on to vote the row up or down. My function was set up to execute an update query that did this:

    update xxx set votes = votes + 1 where xxx

    and vice-versa. It would do this, if necessary, right before reloading the file.

    The odd thing is that the votes would sometimes increment by 1, 2, or even 3.

    I debugged it by doing a get_var prior to the “voting” query executed and echoed the current vote total prior to updating the file. I would get a current vote number of 8, yet once the file was reloaded, it would have a vote value of 10. (And no, *I* was not executing the query more than once – I even unset the $_post variable that was passed to the function after the vote query ran just to make sure).

    It acted like WP was re-executing my query when the “next” query was run. Hence my question: does $wpdb have to be unset somehow?

    Currently I have it fixed by retrieving the vote into a variable, incrementing it in the script, and then updating the file using that variable.

  • The topic ‘$wpdb question…’ is closed to new replies.