2D array problem

bob

Hi,

I am trying to create a 2D array out of two query's with the intention to display each array item as one row in a table:
So if I have these query's:

select place_id from place;
select new_id from new;

the result of place is: 1, 2, 3
the result of new is: 7, 8

now the row should look like: $new_place = array("7"=>array("1","2","3"), "8"=>("1","2","3"))

I tried nesting two while's which read out the query result, that did not seem to work...

Has anyone an idea? thanx for now

barand

$sql1 = mysql_query("select place_id from place"); 
$sql2 = mysql_query("select new_id from new"); 

while ($place = mysql_fetch_row($sql1)) {
     while ($new = mysql_fetch_row($sql2)) {
         $new_place[$place[0]][] = $new[0];
    }
}

hth

bob

Thanx fro your reply Barand,

I've worked out your suggestion and switched the names like this:

while($place = mysql_fetch_row($result_plaats))
{
while($place = mysql_fetch_row($result_plaats))
{
$new_place[$new[0]][] = $place[0];
}
}

//read it out
while(list ($key1) = each($new_place))
{
echo"key1: <br>";
while(list ($key2, $val) = each($new_place["$key1"]))
{
echo"- $val<br>";
}
}

This results in:
2:
-1
4:
-1

Instead of:
2:
-1
-2
-3
4:
-1
-2
-3

I thought of increasing $place[$number] $number++... no luck untill so far

barand

Easiest way to see the results is

echo "<pre>";
print_r ($new_place);
echo "</pre>";

barand

Your inner while loop is same query as the outer!

Weedpacket

Sounds like you want the cartesian product of the two arrays. Problem with nesting the fetch_row calls is that the inner loop will run through all of the records in the second query in the first iteration of the first query, and there won't be any left when it comes time to do the second iteration of the first query.

$sql1 = mysql_query("select place_id from place"); 
$sql2 = mysql_query("select new_id from new");
$places = array();
$news = array();
while($place = mysql_fetch_row($sql1)
	$places[] = $place[0];
while($new = mysql_fetch_row($sql2)
	$news[] = $new[0];

$new_row = array();
foreach($news as $new)
{	$new_row[$new]=$places;
}

To test that of course, set $places=array(1,2,3) and $news=array(7,8), and then see what the last four lines of the above code produce.

barand

While we're talking cartesian

$sql = "select new.new_id, place.place_id from new, place";
$result = mysql_query($sql);
while (list($new, $place) = mysql_fetch_row($result)) {
    $new_place[$new][] = $place;
}

Weedpacket

Heh, true - dunno if it'd be faster, but it's certainly simpler.

bob

Thank you both for helping me out... the result show's now

2:
- 1
- 2
- 3
4:
- 1
- 2
- 3

exactly the way I want. thx

bob

One more thing...

Do you kno how to add more fileds to the array. When I use this query:

select n.new_id, s.name from new as n, shop as s WHERE s.shop_id=n.shop_id;

The fields that I am after are fore instance: n.price, n.head, n.start and so on.

In the end the row should look like:

2(id) - n.price - n.head - n.start - 1 - 2 - 3(place_id's)

any ideas?

barand

$new_price[$new_id]['head'] = $head;
$new_price[$new_id]['price] = $price;

etc

bob

I'm sorry...
but how do I echo this value

I did the following:

$place_result = select from place;
$upload_result = select from upload as u, shop as s where u.shop_id=s.shop_id;

$places = array();
$upload = array();
$shop = array();

while($place = mysql_fetch_row($place_result))
$places[] = $place[0];
while($new = mysql_fetch_row($upload_result))
{
$upload[] = $new[0];
$shop[] = $new[1];
}

foreach($upload as $new)
{
$new_row[$new]=$places;
$new_row[$new]['shop_id']=$shop;
}

while(list($key1) = each($new_row))
{
echo"<tr><td>$key1",-here should be shop_id-</td>";
while(list($key2,$val) = each($new_row["$key1"]))
{
echo"<td>$val</td>";
}
echo"</tr>";
}

barand

Easiest way to see the results is

echo "<pre>";
print_r ($new_place);
echo "</pre>";

bob

this displayes:

Array
(
[2] => Array
(
[0] => 1
[1] => 2
[2] => 3
[winkel_id] => Array
(
[0] => 7
[1] => 16
)

    )

[4] => Array
    (
        [0] => 1
        [1] => 2
        [2] => 3
        [winkel_id] => Array
            (
                [0] => 7
                [1] => 16
            )

    )

)
1

now I thought echo $new_row['winkel_id']; to display the winkel_id... apparently not 🙁

barand

You are creating an array of what I think is shop id's and making the 'shopid' of both equal to that array. I'm guessing a bit here as not too easy with variable names like $row[0].

But what I think you want is

$place_result = select * from place; 
$upload_result = select * from upload as u, shop as s where u.shop_id=s.shop_id; 

$places = array(); 
$upload = array(); 
$shop = array(); 

while($place = mysql_fetch_row($place_result)) 
$places[] = $place[0]; 
while($new = mysql_fetch_row($upload_result)) 
{ 
$upload[] = $new[0]; 
$shop[$new[0]] = $new[1]; 
} 

foreach($upload as $new) 
{ 
$new_row[$new]=$places; 
$new_row[$new]['shop_id']=$shop[$new]; 
} 

echo "<pre>"; 
print_r ($new_row); 
echo "</pre>";

bob

That's is what i did...
I have all the wanted values in the array... the print_r function prints out the array. I want to print the array as a table like:

<tr><td><input type="checkbox" value="upload_id"></td>
<td> a td's copple of other information</td>
<td><input type="checkbox" value="1"></td><td>input type="checkbox" value="2"></td><td>input type="checkbox" value="3"></td></tr>

Situation for example:
check upload_id[7] and place_id 1 of the first row
check upload_id[12] and place_id 2 and 3 of the second row
check upload_id[5] and place_id 2 of the third row

In the end...
run a query:
insert into table values(7, 1)

insert into table values(12, 2)
insert into table values(12, 3)

insert into table values(5, 2)

But I can't get the table correctly displayed...

barand

I altered your code so you didn't allocate an array to shop id in my last post.

To display shop id,

echo "$new_row[2]['shop_id']";


foreach ($new_row as $key => $value) {
    echo "key is $key <br> ";
    foreach ($value as $k => $v) {
          echo "    $k -> $v <br>";
    }

}