loops and arrays

tbuzz

I'm trying to build a graph from a mysql table, I've found a chart script I want to use but I'm struggling to organise the data properly. The query will give a different number of results each time.

my db table
columns id | n1 | v1 | v2 | v3 | c1 |

                        n1.1    v1.1    v2.1    v3.1

data n1.2 v1.2 v2.2 v3.2
n1.3 v1.3 v2.3 v3.3

the query

$val = $_GET['val'];
$result = "select n1,v1,v2,v3 where c1 = $val order by n1";

and what I'm trying to get to

arr1= array ( array ($n = n1.1, n1.2, n1.3)
array ($va = v1.1, v1.2, v1.3)
array ($vb = v2.1, v2.2, v2.3)
array ($vc = v3.1, v3.2, v3.3) )

I've been working through a couple of tut's but I'm really struggling with looping through multiple arrays, any help or pointers to examples would be appreciated

Krik

The question is what are you doing with "$result". Because till you query it, it is just a string.

$qry = "select n1,v1,v2,v3 where c1 = $val order by n1";

$res = mysql_query($qry);

$arr = mysql_fetch_array($res);

print_r($arr);

The print_r should display an array. That array can then be looped through with a foreach or while loop.

foreach ($arr as $key => $val) {
echo $key . ' ' . $val . '<br>';
}

tbuzz

thanks for that but when it only loops through the first set of values for n1. I need to loop through n1 and return sub-arrays(?) for v1, v2 and v3.
Everything I read confuses me a little more...

__berfuzz

If $arr1 is a 2 dimensional array you can print it in a table like this. (I didn't quite get the problem but foreach will loop through $arr1 for you.)

echo "<table>";
foreach($arr1 as $subarr)
{
   echo "<tr>";
   foreach($subarr as $value)
   {
      echo "<td>".$value."</td>";
    }
   echo "</tr>";
}
echo "</table>";

tbuzz

Hi Uber, I think you're jumping ahead of where I am.....

I can loop through the first column (n1) . From different tut's I can do this a couple of ways

$array = array();
while ($row = mysql_fetch_assoc($res))
$array[] = $row['n1'];

and this returns the first array how I want it

print_r($array);
echo '<br /><br />';
foreach ($array as $key => $val) {
echo $key . ' ' . $val . '<br>';
}

what I need to do is add sub arrays for v1,v2 + v3

__berfuzz

So, you have a slq-table with thees columns:

id | n1 | v1 | v2 | v3 | c1

Now you want to muster a array like this:

$arr1 = array ( array (n1.1, n1.2, n1.3)
                   array (v1.1, v1.2, v1.3)
                   array (v2.1, v2.2, v2.3)
                   array (v3.1, v3.2, v3.3) )

It would be easier to advice you if I knew what info the different columns are holding... However I could guess. n is the name of something in the graph. v1, v2 and v3 are points or values. If so you could make an associative array. Like this:

Array
(
    [first_name] => Array
        (
            [v1] => something
            [v2] => something
            [v3] => something
        )
    [second_name] => Array
        (
            [v1] => something
            [v2] => something
            [v3] => something
        )

)

Then you won't have to mix values with names like you do in the array you're looking to make.

shawty

I agree with Uberfuzz, can we see a sample of what your table is holding?

Could you maybe export say the first 10 rows into a text file, zip them and attach them to a post using the attach files function, this would at least allow us to see the structure of the database.

From reading your description, you appear to be under the impression that a column in the DB is fully accessible as an array of all the records down that column when you select some data, but it's not. Your data is actually retrieved across in rows.

So in your description of columns above, if you have :

id | n1 | v1 | v2 | v3 | c1

The every time you do a "$row = mysql_fetch_assoc($res)" you will get an array that looks like this :

$row['id'] = id;
$row['n1'] = n1;
$row['v1'] = v1;
$row['v2'] = v2;
$row['v3'] = v3;
$row['c1'] = c1;

If you have the following data :

0,1,2,3,4,5
1,6,7,8,9,10
2,11,12,13,14,15

Then for 3 runs round a loop you'll get the following :

Loop 1
$row['id'] = 0;
$row['n1'] = 1;
$row['v1'] = 2;
$row['v2'] = 3;
$row['v3'] = 4;
$row['c1'] = 5;

Loop 2
$row['id'] = 1;
$row['n1'] = 6;
$row['v1'] = 7;
$row['v2'] = 8;
$row['v3'] = 9;
$row['c1'] = 10;

Loop 3
$row['id'] = 2;
$row['n1'] = 11;
$row['v1'] = 12;
$row['v2'] = 13;
$row['v3'] = 14;
$row['c1'] = 15;

At first glance it appears to me that for every 3 rows, your storing 3 sets of values, but quite what the significance of those values are i can't quite work out.

If this is what your doing, then each time round the loop your going to need to read 3 rows.

$row1 = mysql_fetch_assoc($res);
$row2 = mysql_fetch_assoc($res);
$row3 = mysql_fetch_assoc($res);

Then your 3 sets of values for N1 would be in, $row1['n1'],$row2['n1'] and $row3['n1'] respectively.

However this is just a guess based on how i read your initial description.

It may also help if you could point us to the chart script your using too, se we can all see how it expects the data to be provided to it.

Cheers

Shawty