Page 1 of 1

Problems with using multiarrays

Posted: Mon Mar 08, 2004 4:50 am
by redtux
This is something I have been wrestling with for a few days.

I have several arrays with I want to join and then access each joined array seperately eg:

Code: Select all

<?php
$id = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13);
$firstname = array(mike, tom, nick, cynthia,manak,alan,louise,cedric,alex,chris,emma,allison,sarah);
$lastname = array(martin, thomas, king, courtier, davis, crisp, blair, singh, jones, smith, jenkins, don, anelka);
$multi = array($id, $firstname, $lastname);
foreach ($multi as $v)&#123;
foreach ($v as $v1)&#123;
echo ("$v1\n");
&#125;
&#125;
?>
This outputs
1 2 3 4 5 6 7 8 9 10 11 12 13 mike tom nick cynthia manak alan louise cedric alex chris emma allison sarah martin thomas king courtier davis crisp blair singh jones smith jenkins don anelka

ie: each array is appended to the end of the previous, whilst what I want is each line to be like this

array1[0], array2[0],array2[0]
array1[1], array2[1],array2[1]
array1[2], array2[2],array2[2]
array1[3], array2[3],array2[3]
array1[4], array2[4],array2[4]

I keep trying different approaches but keep coming back to this

any help appreciated

Posted: Mon Mar 08, 2004 5:00 am
by markl999
Like this?

Code: Select all

<?php
$id = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13);
$firstname = array('mike', 'tom', 'nick', 'cynthia', 'manak', 'alan',
  'louise', 'cedric', 'alex', 'chris', 'emma', 'allison', 'sarah');
$lastname = array('martin', 'thomas', 'king', 'courtier', 'davis', 'crisp',
  'blair', 'singh', 'jones', 'smith', 'jenkins', 'don', 'anelka');
$multi = array($id, $firstname, $lastname);
$total = count($id);
for($x=0;$x<$total;$x++){
  for($y=0;$y<3;$y++){
    echo $multi[$y][$x].'<br />';
  }
}
?>

Posted: Mon Mar 08, 2004 8:45 am
by redtux
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++)&#123;
for ($y=0;$y<3;$y++)&#123;
$myarray2 = array($multi&#1111;$y]&#1111;$x]);
print_r($myarray2);

//$query = "SELECT contact_id, first_name, lastname FROM tb_contacts WHERE contact_id = $multi&#1111;$y]&#1111;0]";
//$result = pg_exec($db, $query);
//print $result;
&#125;
echo ('<br />');
echo ('<br />');
&#125;

?>
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.