assign mysql values into multidimensional array

Question

I am trying to display a multidimensional array into html table using php nd mysql.

The array structure is like below

Array
(
    [az] => Array
        (
            [0] => Array
                (
                    [work] => dsdsds
                    [time] => 2:47---2:55
                    [total] => 8
                )

        )

    [an] => Array
        (
            [0] => Array
                (
                    [work] => sdsdsdsdsd
                    [time] => 1:47---2:47
                    [total] => 60
                )

        )

    [mu] => Array
        (
            [0] => Array
                (
                    [work] => sdsdsd
                    [time] => 1:30---2:48
                    [total] => 78
                )

        )

    [raj] => Array
        (
            [0] => Array
                (
                    [work] => dsdwew
                    [time] => 3:34---3:40
                    [total] => 6
                )

            [1] => Array
                (
                    [work] => cdsfdfdfd
                    [time] => 3:25---3:35
                    [total] => 10
                )

        )

)

it will go through columns first and then it will come to rows like this

user1   user2   user3
aa      bb      cc

Plz suggest..

You should supply an example of the data, and what the output would look like using that data. Right now your data and example don't match. — goat
– goat, Commented Feb 3, 2010 at 16:36

oneat · Accepted Answer · 2010-02-03 10:53:34Z

1

U should read about foreach.

http://php.net/manual/en/control-structures.foreach.php

And I think that inserting this values into table won't be any problem.

answered Feb 3, 2010 at 10:53

oneat

11k17 gold badges55 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ntan · Accepted Answer · 2010-02-03 12:26:40Z

0

If i understand your question write that's what y need

    foreach($array as $tr=>$trData)
    {
      echo "<tr>{$trData["which field you want to display"]}</tr>";

      echo "<tr>";
      foreach($tdData as $td=>$tdData)
      {
         echo "<td>{$tdData["which field you want to display"]}</td>";
      }
    echo "</tr>";
    }

answered Feb 3, 2010 at 12:26

ntan

2,2057 gold badges36 silver badges60 bronze badges

Collectives™ on Stack Overflow

assign mysql values into multidimensional array

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related