export playernotes holdem manager

<?php

$con="host=localhost port=5432 dbname=Holdemmanager2 user=new password=newpass"; //Here is connect to PSQ 9.1, change connection info for yours
$db=pg_connect($con) or die('connection failed');
echo 'Connected to: ', pg_dbname($db);


$query = "SELECT playername, category_id, icon_id, note, display_order, date_created, gamenumber FROM player_notes,players WHERE players.player_id = player_notes.player_id";

$wynik = pg_query($query) or die('Wrong query: ' . pg_last_error());
pg_close($db);


$con="host=localhost port=5433 dbname=HoldemManager2psq84 user=new password=newpass"; //Here is connect to PSQ 8.4, change connection info for yours
$db=pg_connect($con) or die('connection failed');
echo 'Connected to: ', pg_dbname($db);

   while($rek = pg_fetch_array($wynik)) {



     $q = "SELECT player_id FROM players WHERE playername = '$rek[playername]'";


      $wyq = pg_query($q);


        while($r = pg_fetch_array($wyq)) {


        $qq = "INSERT INTO player_notes (player_id,category_id,icon_id,note,display_order,gamenumber) VALUES ($r[player_id],$rek[category_id],$rek[icon_id],'$rek[note]',$rek[display_order],$rek[gamenumber])";

        $wyqq = pg_query($qq) ;
        }



    }



?>