connect 2 different databases

    $dbuser = 'xxx';
	$dbpass = 'xxx';
	$dbhost = 'localhost';
	$dbname = 'journaldemo';
    $dbname2 = '1timebarcode'; 
    
	$con = mysql_connect($dbhost,$dbuser,$dbpass);
	mysql_select_db($dbname, $con);
	
	 
	$con2 = mysql_connect($dbhost,$dbuser,$dbpass);
	mysql_select_db($dbname2, $con2); 
	$sql = "(SELECT 	t.transid, t.tdate, t.location, t.pc, SUM(tv.tamount) AS tamount, l.code, l.ttype, 'POINTS' AS tid
			  FROM		transactions t INNER JOIN tvalues tv ON tv.transid2 = t.transid
						INNER JOIN lookups l ON l.ttype = tv.ttype
						LEFT OUTER JOIN washes w ON w.transid = t.transid
			  WHERE		(t.tdate BETWEEN '2009-03-28' AND '2009-10-27')
						AND (t.pc BETWEEN '20000000' AND '79999999')
						AND l.code IN ('E', 'G', 'M', 'O', 'F', 'H', 'N', 'Q', 'P')
						AND l.ttype NOT IN('4002', '4408')
						AND w.transid IS NULL
			  GROUP BY 	t.transid)
			  UNION
			  (SELECT 	t.transid, t.tdate, t.location, t.pc, SUM(tv.tamount) AS tamount, l.code, l.ttype, 'WASHES' AS tid
			   FROM		transactions t INNER JOIN tvalues tv ON tv.transid2 = t.transid
						INNER JOIN lookups l ON l.ttype = tv.ttype
						LEFT OUTER JOIN washes w ON w.transid = t.transid
			   WHERE 	(t.tdate BETWEEN '2009-03-28' AND '2009-10-27')
						AND (t.pc BETWEEN '20000000' AND '79999999')
						AND l.ttype IN ('4060','10110', '10400', '11000', '11001', '11010', '11011', '11013', '18000', '18001', '11016')
						AND w.transid IS NULL
			   GROUP BY t.transid)";
	
	$result = mysql_query($sql);
	
	while($row = mysql_fetch_array($result)) { 
//need to connect to 2nd db to do update if this is true 
		if ($row['pc'] >= "30000000" || $row['pc'] <="39999999") {
			
			$sql = "UPDATE barcodes SET active = 0            
					WHERE 	human = '".$row['pc']."'"; 
			if (!mysql_query($sql, $con2)) die(mysql_error());
	
		}
		elseif ($row['tid'] == "WASHES") {
			$sql = "INSERT INTO punch (pc, punchval) 
					VALUES ('".$row['pc']."', 1) 
					ON DUPLICATE KEY UPDATE punchval = punchval + 1";
			
			if (!mysql_query($sql, $con)) die(mysql_error());
			
			$sql = "UPDATE 	punch SET punchval = CASE WHEN punchval > 10 THEN punchval - 11            
												 ELSE punchval + (-11) END	
					WHERE 	pc = '".$row['pc']."'
							AND EXISTS (SELECT 	*
										FROM 	tvalues JOIN lookups ON lookups.ttype = tvalues.ttype 
										WHERE 	tvalues.transid2 = '".$row['transid']."' AND lookups.ttype IN ('4980','4981'))";
			
			if (!mysql_query($sql, $con)) die(mysql_error());