Array problem

oaskedal

Hi!

How can I find the repeating value 'Tablename' and it's current indexkey in the [Fieldnames] array?
i.e. output I'd like: "Tablename and key is [0]", "Tablename and key is [4]", and so on everytime it appears.. (Also - the array may increase and there's no logical pattern between every Tablename...)

Here is an example:

Here is a print_r() I've done of my array:



Array
(
    [Fieldnames] => Array
        (
            [0] => Tablename
            [1] => somevalues
            [2] => somevalues
            [3] => somevalues
            [4] => Tablename
            [5] => somevalues
            [6] => somevalues

    )


)

NogDog

foreach($array_variable[Fieldnames] as $key => $value)
{
   if($value == 'Tablename')
   {
      echo "Tablename and key is [".$key."]<br />\n";
   }
}

oaskedal

NogDog wrote:

foreach($array_variable[Fieldnames] as $key => $value)
{
   if($value == 'Tablename')
   {
      echo "Tablename and key is [".$key."]<br />\n";
   }
}

Thanks!

How can I also include the values underneath every 'Tablename' and their keys in the output?

i.e.

"Tablename and key is [0]
"somevalue and key is [1]"
"somevalue and key is [2]"
"somevalue and key is [3]"
"Tablename and key is [4]
"somevalue and key is [5]"
"somevalue and key is [6]"

and so on..

The idea is to create a sql-statement out of it.
I have an idea for the loop, but I don't know how to set the right condition:

For every index key equal to 'Tablename' -> fetch the somevalue and their keys underneath until you reach the next index key with value 'Tablename'

NogDog

Are you stuck with that array structure? It would be much easier (and logical) to add some dimensions to it so that you could more easily "walk" through it, such as with a foreach() loop. It might be something like:

$array = array(
   'TableName_1' => array(
      'value 1.1',
      'value 1.2',
      'value 1.3'
   ),
   'TableName_2' => array(
      'value 2.1',
      'value 2.2',
      'value 2.3'
   )
);

Then you could just do:

foreach($array as $table => $values)
{
   // do something with string $table and its array of $values
}

oaskedal

NogDog wrote:
Are you stuck with that array structure? It would be much easier (and logical) to add some dimensions to it so that you could more easily "walk" through it, such as with a foreach() loop. It might be something like:
$array = array(
   'TableName_1' => array(
      'value 1.1',
      'value 1.2',
      'value 1.3'
   ),
   'TableName_2' => array(
      'value 2.1',
      'value 2.2',
      'value 2.3'
   )
);
Then you could just do:
foreach($array as $table => $values)
{
   // do something with string $table and its array of $values
}

I'm not sure I understood that entirely :queasy:

I put my totalarray under. I need to put it out different table based on 'Tablename' (value beeing tables name) as one condition to seperate both the sql-statement and the tables.

array("Tablename => $_POST['tablename'], "Subject" => $_POST['tableSubject'], "Values"=> $_POST['tableValues']);

this would give med:

Array
(
    [Tablename] => Array
        (
            [0] => aTableName
            [1] => someOtherTableName
        )

[Subject] => Array
    (
        [0] => someSub
        [1] => someSub
        [2] => someSub
        [3] => someSub
    )

[Values] => Array
    (
        [0] => some value
        [1] => some value
        [2] => some value
        [3] => some value
    )

)

but then again, maybe there is some better way around, just me not getting it..
Any suggestions..??

NogDog

I guess if I had a better idea as to the origin of the data in the array and what it is supposed to represent, I could give a better answer. Ideally, you want the structure of the array to mirror the logical structure of the data it contains: if the "tablename" elements represent things that have multiple "other" things related to them, then those "other" things should be at a subordinate level in the array, associated to those "tablename" things. Or to try to put that in normal English, their should be a hierarchical structure to the array that represents the hierarchical structure of the data to be stored in it.