[SOLVED] A quick question...What am I missing?

[makatee]

I'm new here so please don't kill me. I am working a summber job and the company wanted me to do some PHP work for them. I have learned it pretty quickly, but this morning I am just having a brain fart on something and I can't figure out what I am missing.

 

i want to build and array like this but need to loop thru my dataset to assign it:

 

    $rows = array(

                array('id' => '1', 'name' => 'B'),

                array('id' => '3', 'name' => 'C'),

                array('id' => '2', 'name' => 'A')

                  );

 

so i did this:

 

        $linecnt=0;

        $rs->MoveFirst(); //go to the first record

 

        while (!$rs->EOF)  //carry on looping through while there are records

            {

            // build arrays

 

            $seq[] = $rs->Fields(0)->value;

            $div[] = $rs->Fields(4)->value;

            $imp[] = $rs->Fields(5)->value;

            $mawb[]= $rs->Fields(11)->value;

            $hawb[]= $rs->Fields(18)->value;

            $exptd[]=$rs->Fields(26)->value;

            $recvd[]=$rs->Fields(27)->value;

            $shpd[] =$rs->Fields(28)->value;

            $cntnr[]=$rs->Fields(15)->value;

            }

        $grid_ary = array($seq, $div, $imp, $mawb, $hawb, $exptd, $recvd, $shpd, $cntnr);

 

 

which gives me this:

1. 500776 500777 500778 500779

2. MII MII MII MII

3. MII MII MII MII

4. MOLU411751906 MOLU411751906 MOLU411751906 MOLU411751906

5. CMB857087 CMB857087 CMB857087 CMB857087

6. 11 8 6 12

7. 0 0 0 0

8. 0 0 0 0

9. MAXU6212680 MAXU6212680 MAXU6212680 MAXU6212680

 

instead of what i need which is like this:

 

seq........Div... Imp... PO... Mawb ................... hawb ..............Exptd... Recvd... Shpd... Container

500776 ... MII ... MII ... MOLU411751906 ... CMB857087 ... 11 ... 0 ... 0 ... MAXU6212680

500777 ... MII ... MII ... MOLU411751906 ... CMB857087 ... 8 ... 0 ... 0 ... MAXU6212680

500778 ... MII ... MII ... MOLU411751906 ... CMB857087 ... 6 ... 0 ... 0 ... MAXU6212680

500779 ... MII ... MII ... MOLU411751906 ... CMB857087 ... 12 ... 0 ... 0 ... MAXU6212680

 

What am I missing guys?

[rhodesa]

<?php
         $linecnt=0;
         $rs->MoveFirst(); //go to the first record
         $records = array();

         while (!$rs->EOF)  //carry on looping through while there are records
         {
             $record = array(
                 'seq' => $rs->Fields(0)->value,
                 'div' => $rs->Fields(4)->value,
                 'imp' => $rs->Fields(5)->value,
                 'mawb' => $rs->Fields(11)->value,
                 'hawb' => $rs->Fields(18)->value,
                 'exptd' => $rs->Fields(26)->value,
                 'recvd' => $rs->Fields(27)->value,
                 'shpd' => $rs->Fields(28)->value,
                 'cntnr' => $rs->Fields(15)->value
             );
             $records[] = $record;
         }
?>

[makatee]

<?php
         $linecnt=0;
         $rs->MoveFirst(); //go to the first record
         $records = array();

         while (!$rs->EOF)  //carry on looping through while there are records
         {
             $record = array(
                 'seq' => $rs->Fields(0)->value,
                 'div' => $rs->Fields(4)->value,
                 'imp' => $rs->Fields(5)->value,
                 'mawb' => $rs->Fields(11)->value,
                 'hawb' => $rs->Fields(18)->value,
                 'exptd' => $rs->Fields(26)->value,
                 'recvd' => $rs->Fields(27)->value,
                 'shpd' => $rs->Fields(28)->value,
                 'cntnr' => $rs->Fields(15)->value
             );
             $records[] = $record;
         }
?>

 

Thanks a lot sir. That was exactly what I was missing.