I'm implementing a voting system in my photo log cms.
i wnat to update the entry_rank by pulling the value increaing by one and updating. I have this working already.

I've read that you cannot insert rows in multiple talbe in one query but can i update the one and insert a row to the vote table (i want to record the voters ip, date etc)