Thanks that worked - only problem now is that I cant re-extract the values ie: this is the output of
Code: Select all
<?php
$db = pg_connect("dbname=data_cc");
$multi = array($id, $firstname, $lastname);
$total=count($id);
for($x=0;$x<$total;$x++){
for ($y=0;$y<3;$y++){
$myarray2 = array($multiї$y]ї$x]);
print_r($myarray2);
//$query = "SELECT contact_id, first_name, lastname FROM tb_contacts WHERE contact_id = $multiї$y]ї0]";
//$result = pg_exec($db, $query);
//print $result;
}
echo ('<br />');
echo ('<br />');
}
?>
Array ( [0] => 27 ) Array ( [0] => Leo ) Array ( [0] => Goodridge )
Array ( [0] => 28 ) Array ( [0] => Martins156 ) Array ( [0] => Vegoda )
Array ( [0] => 18 ) Array ( [0] => d ) Array ( [0] => Russell )
Array ( [0] => 33 ) Array ( [0] => e ) Array ( [0] => Bagg )
Array ( [0] => 34 ) Array ( [0] => r ) Array ( [0] => Brown )
Array ( [0] => 35 ) Array ( [0] => w ) Array ( [0] => Palmer )
Array ( [0] => 38 ) Array ( [0] => g ) Array ( [0] => Pearson )
Array ( [0] => 26 ) Array ( [0] => j ) Array ( [0] => Francis )
Array ( [0] => 31 ) Array ( [0] => ) Array ( [0] => Hazel )
Array ( [0] => 32 ) Array ( [0] => j ) Array ( [0] => Wood )
Array ( [0] => 14 ) Array ( [0] => l ) Array ( [0] => Warburton )
Array ( [0] => 20 ) Array ( [0] => u ) Array ( [0] => Moore )
Array ( [0] => 21 ) Array ( [0] => k ) Array ( [0] => Gorman )
Array ( [0] => 25 ) Array ( [0] => r ) Array ( [0] => Armitage )
Array ( [0] => 39 ) Array ( [0] => y ) Array ( [0] => Whitford )
Array ( [0] => 29 ) Array ( [0] => j ) Array ( [0] => Hui )
Array ( [0] => 15 ) Array ( [0] => ) Array ( [0] => Miller )
Array ( [0] => 23 ) Array ( [0] => ) Array ( [0] => Khandker )
Array ( [0] => 19 ) Array ( [0] => ) Array ( [0] => Courtier )
Array ( [0] => 11 ) Array ( [0] => ) Array ( [0] => Jelley )
Array ( [0] => 10 ) Array ( [0] => ) Array ( [0] => Trevelyan )
Array ( [0] => 24 ) Array ( [0] => ) Array ( [0] => James )
Array ( [0] => 9 ) Array ( [0] => ) Array ( [0] => Broom )
Array ( [0] => 13 ) Array ( [0] => ) Array ( [0] => Amaechi )
Array ( [0] => 36 ) Array ( [0] => ) Array ( [0] => Husband )
Array ( [0] => 37 ) Array ( [0] => ) Array ( [0] => Kitchenham )
Array ( [0] => 40 ) Array ( [0] => l ) Array ( [0] => Lockyer )
Array ( [0] => 30 ) Array ( [0] => l ) Array ( [0] => Wong )
Array ( [0] => 16 ) Array ( [0] => t ) Array ( [0] => Bartlett )
Array ( [0] => 17 ) Array ( [0] => u ) Array ( [0] => Gallacher )
Array ( [0] => 22 ) Array ( [0] => u ) Array ( [0] => Joyner )
Array ( [0] => 12 ) Array ( [0] => u ) Array ( [0] => Burton )
As can be seen everything is keyed to [0] so I cant extract within the loop.