combineren van 2 scripts

<?php
if(mysql_connect($host,$username,$password))
{
    if(!mysql_select_db($database))
    {
        echo 'Sorry, ik kon helaas geen verbinding maken met de databasetabel!';
    }
}else{
    echo 'Sorry, ik kon helaas geen verbinding maken met de databaseserver!';
    exit;
}
$select_language    = "SELECT `lang` FROM `taal` WHERE `ip` = '". $_SERVER['REMOTE_ADDR'] ."'";
$query_language        = mysql_query($select_language) OR DIE (mysql_error());

if(mysql_num_rows($query_language) == 0){
     include('language/eng.lang.php');
     $row = 0;
}
else{
    $row_language = mysql_fetch_assoc($query_language);
    if(file_exists('language/'.$row_language['lang'] .'.lang.php')){
      include('language/'.$row_language['lang'] .'.lang.php');
    }
    else{
        include('language/eng.lang.php');
    }
    $row = 1;
}
if(isset($_GET['lang'])){
    $_GET['lang'] = mysql_real_escape_string($_GET['lang']);
    if($row == 1){
        $query_insert_lang = mysql_query("UPDATE `taal` SET `lang` = '". $_GET['lang'] ."' WHERE `ip` = '". $_SERVER['REMOTE_ADDR'] ."'") OR DIE (mysql_error());
    }
    else{
        $query_insert_lang = mysql_query("INSERT into `taal` SET `lang` = '". $_GET['lang'] ."', `ip` = '". $_SERVER['REMOTE_ADDR'] ."'") OR DIE (mysql_error());
    }
    
    if(file_exists('language/'.$_GET['lang'] .'.lang.php')){
    include('language/'.$_GET['lang'] .'.lang.php');
    }
    else{
        include('language/eng.lang.php');
    }
}
?>  

<?php
if(mysql_connect($host,$username,$password))
{
    if(!mysql_select_db($database))
    {
        echo 'Sorry, ik kon helaas geen verbinding maken met de databasetabel!';
    }
}else{
    echo 'Sorry, ik kon helaas geen verbinding maken met de databaseserver!';
    exit;
}
$select_language    = "SELECT `lang` FROM `taal` WHERE `ip` = '". $_SERVER['REMOTE_ADDR'] ."'";
$query_language        = mysql_query($select_language) OR DIE (mysql_error());
 
if(mysql_num_rows($query_language) == 0){
     include('language/eng.lang.php');
     $row = 0;
}
else{
    $row_language = mysql_fetch_assoc($query_language);
    if(file_exists('language/'.$row_language['lang'] .'.lang.php')){
      include('language/'.$row_language['lang'] .'.lang.php');
    }
    else{
        include('language/eng.lang.php');
    }
    $row = 1;
}
if(isset($_GET['lang'])){
    $_GET['lang'] = mysql_real_escape_string($_GET['lang']);
    if($row == 1){
        $query_insert_lang = mysql_query("UPDATE `taal` SET `lang` = '". $_GET['lang'] ."' WHERE `ip` = '". $_SERVER['REMOTE_ADDR'] ."'") OR DIE (mysql_error());
    }
    else{
        $query_insert_lang = mysql_query("INSERT into `taal` SET `lang` = '". $_GET['lang'] ."', `ip` = '". $_SERVER['REMOTE_ADDR'] ."'") OR DIE (mysql_error());
    }
 
    if(file_exists('language/'.$_GET['lang'] .'.lang.php')){
    include('language/'.$_GET['lang'] .'.lang.php');
    }
    else{
        include('language/eng.lang.php');
    }
}
?>

<?php 
$db_host = "localhost"; // vul hier het adres van de server in 
$db_login = "test"; // je loginnaam 
$db_pass = "test"; // Je password 
$db_database = "shenzhou-university"; // naam van de database 
mysql_connect($db_host, $db_login, $db_pass) or die("MySQL connectie mislukt."); 
mysql_select_db($db_database)or die("Selecteren van database mislukt.");
$query = "SELECT id, titel_nl FROM nieuws"; 
$resultaat = mysql_query($query) or die ("query mislukt"); 
   while ($obj = mysql_fetch_object($resultaat)){ 
echo "<A HREF='toonbericht.php?id=$obj->id'>$obj->titel_nl</A><BR>"; 
   } 
   
 
?>  

<?php 
$db_host = "localhost"; // vul hier het adres van de server in 
$db_login = "test"; // je loginnaam 
$db_pass = "test"; // Je password 
$db_database = "shenzhou-university"; // naam van de database 
mysql_connect($db_host, $db_login, $db_pass) or die("MySQL connectie mislukt."); 
mysql_select_db($db_database)or die("Selecteren van database mislukt.");
$query = "SELECT id, titel_nl FROM nieuws"; 
$resultaat = mysql_query($query) or die ("query mislukt"); 
   while ($obj = mysql_fetch_object($resultaat)){ 
echo "<A HREF='toonbericht.php?id=$obj->id'>$obj->titel_nl</A><BR>"; 
   } 
 
 
?>