[Dean C]

Hehe probably Basically i'm upgrading my battle system to work vB3. I have my table structure like so:

CREATE TABLE `battle_records` ( 
   `battleid` smallint(5) unsigned NOT NULL auto_increment, 
   `userid1` smallint(5) unsigned NOT NULL default '0', 
   `userid2` smallint(5) unsigned NOT NULL default '0', 
   `votesforuserid1` smallint(5) unsigned NOT NULL default '0', 
   `votesforuserid2` smallint(5) unsigned NOT NULL default '0', 
   `threadid` text NOT NULL, 
   `battletype` varchar(50) NOT NULL default '', 
   `timeadded` int(14) default NULL, 
    `winner` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`battleid`) 
 ) TYPE=MyISAM AUTO_INCREMENT=1888 ;

Now I want to keep a log of all my users wins/losses. I'd rather do this every night and restrict it to one table than having to manage several tables when I go to edit/delete a battle. So the situation i'm faced with is updating every user on my boards win/loss tally in the user table. That way I can display the information in the postbit/profile without any extra queries