dynamically adding to multidimensiona l array

[pauld]

$sql= sql query
$i=0;

while
($a2=mysql_fetc h_array($a1)){a rray_push($temp array,$a2[0],$a2['ad'],$a2[1],$a2[1]);
{
I want this array to be the value of an asssoc. array $results[$i]
$results[$i] =$temparray doesnt work
$results[$i] =$temparray[] doesnt work
$results[$i][] =$temparray doesnt work
$results[$i] =>$temparray doesnt work

then $i++;
}
so what does ?

[Mustafa Yalcin Acikyildiz]

try so
$results[$i] .= array($temparra y)

maybe work :)

[Mara Guida]

pauld wrote:

$sql= sql query
$i=0;

while ($a2=mysql_fetc h_array($a1)) {
array_push($tem parray,$a2[0],$a2['ad'],$a2[1],$a2[1]);
{ I want this array to be the value of an asssoc. array $results[$i]
$results[$i] =$temparray doesnt work

<snip>

Why doesn't this work?
What's the error message?
What did you expect and what's the outcome?

Try inserting these two lines at the top of your script
ini_set('displa y_errors', '1');
error_reporting (E_ALL);

[pauld]

Thanks. adding the error reporting gives me a load of stuff about array
indiceds not defined. i thought PHP dynamically sorted out array
lengths. is there a 'better' way to do it than just let the scriptsort
it out ?

I want my results to end up as

results[0] => date,ID,value
results[1] => date,ID,value
results[2] => date,ID,value
etc etc

( there is probably a better way of resetting the temparray but ive
not found it !)

$i=0;
while ($a2=mysql_fetc h_assoc($a1))
{$temparray=arr ay();
array_push($tem parray,$a2['ID'].$a2['date'],$a2['value']);
$results[$i] = array($temparra y);
if (isset($temparr ay)) {reset($temparr ay);}
print '<br>'.$i.':';
print_r($result s[$i]).'<br>';
$i=$i++;
}
gives

0:Array ( [0] => Array ( [0] => 2005-10-07 [1] => 350 [2] => 21 ) )

0:Array ( [0] => Array ( [0] => 2005-10-28 [1] => 473 [2] => NC2 ) )

0:Array ( [0] => Array ( [0] => 2005-10-03 [1] => 337 [2] => NC4 ) )

dont know why the $i counter is incrementing the array

[Mara Guida]

pauld wrote:

is there a 'better' way to do it than just let the scriptsort
it out ?
Yes :)
I want my results to end up as

results[0] => date,ID,value
results[1] => date,ID,value
results[2] => date,ID,value
etc etc

( there is probably a better way of resetting the temparray but ive
not found it !)
see below (*)
$i=0;
while ($a2=mysql_fetc h_assoc($a1))
{$temparray=arr ay();
array_push($tem parray,$a2['ID'].$a2['date'],$a2['value']);
$results[$i] = array($temparra y);
if (isset($temparr ay)) {reset($temparr ay);}
print '<br>'.$i.':';
print_r($result s[$i]).'<br>';
$i=$i++;

<snip>

Don't do this!
$var++ already increments it just by itself.
You really shouldn't assign that to the same var.

Try this (can you predict the output before running the script?):
<?php
$a = 1;
$a++;
echo $a, "<br/>\n";

echo $a++, "<br>\n";
$b = $a++;
echo $b, "<br>\n";
$c = ++$a;
echo $c, "<br>\n";
?>

(*) how to put the return from the database into the $results array

<?php
// ...
$results = array(); // initialize $results
while ($a2 = mysql_fetch_ass oc($a1)) {
// this construct adds an element to the $results array
$results[] = array($a2['date'], $a2['ID'], $a2['value']);
}
// DEBUGGING
echo '<pre>'; print_r($result s); echo '</pre>';
// ...
?>