Update tussen 2 tabellen in db

//Car Racing Updates


include ( 'race/function.check.php' );


$mintotaal = 5;


$oQuery = mysql_query ( ' SELECT * FROM `autorace` WHERE `race_winner` IS NULL ' );
while ( $oFetch = mysql_fetch_assoc ( $oQuery ) )
{


    if ( checktime ( $oFetch['race_date'] ) == FALSE )
    {
        
        $members = explode ( ',' , $oFetch['race_members'] );
        $count = count( $members ) - 1;
        
        $random = mt_rand( 0, $count );
        if ( $count == 0 )
        {
            
            mysql_query ( ' UPDATE `users` SET
                    
            `race_done` = `race_done` + 1,
            `race_car_type` = NULL, 
            `contant` = `contant` + ' . $oFetch['race_money'] . '
            
            WHERE
            `login` = "' .  $oFetch['race_creator'] . '"')    
            or die (mysql_error());
        }
        else
        {
            foreach ( $members as $member )
            {
                if ($member == $members[$random])
                {
                    $race_money = $oFetch['race_money'] * count( $members );
                    mysql_query ( ' UPDATE `users` SET
                    
                        `race_won` = `race_won` + 1 ,
                        `race_done` = `race_done` + 1,
                        `race_money_won` = `race_money_won` + ' . $race_money . '
                        `race_car_type` = NULL 
                        
                        WHERE
                        `login` = "' .  $member . '"');  
             
                }
                else
                {
                    
                        mysql_query ( ' UPDATE `users` SET
                        
                        `race_won` = `race_won` + 1 ,
                        `race_done` = `race_done` + 1,
                        `race_money_won` = `race_money_won` + ' . $race_money . '
                        `race_car_type` = NULL 
                        
                        WHERE
                        `login` = "' .  $member . '"');          
                    
                }
            }
        }
        mysql_query ( ' UPDATE `autorace` SET `race_winner` = "' . $members[$random] . '" ' );
		mysql_query ( ' UPDATE `users` SET `race_car_type` = NULL WHERE `login` = "' .  $member . '"'); 
		mysql_query ( ' UPDATE `users` SET `race_money_won` = `race_money_won` + ' . $race_money . ' WHERE `login` = "' .  $members[$random] . '"');  
		
		mysql_query ( ' UPDATE `users` SET `bank` = `bank` + ' . $race_money . ' WHERE `login` = "' .  $members[$random] . '"'); 
		
 
    }
    
}

<?php


/**
 * @author Patrick Rennings
 * @copyright 2010
 * @filename function.check.php 
 * @version 1.0 - Release
 * 
 * @purphase
 * Check the time if the time is in the past or in the future if in the past return FALSE otherwise
 * return TRUE
 */


function checktime($date)
{
    if(empty($date)) {
        return "No date provided";
    }
   
    $periods         = array("seconde", "minuut", "uren", "dag", "week", "maand", "jaar", "decenium");
    $lengths         = array("60","60","24","7","4.35","12","10");
   
    $now             = time();
    $unix_date         = strtotime($date);
   
       // check validity of date
    if(empty($unix_date)) {   
        return "Slechte datum";
    }


    // is it future date or past date
    if($now > $unix_date) {   
        return FALSE;
    } else {
        return TRUE;
    }
}
?>