Too complicated?!

[Beanmaster]

Hi,
i made a php file which reads some data from a mysql-db and returns the variables to flash.

But I've heard that arrays take up lots of memory, so I would like to keep my code more simple.

I would be thankful for some help.

Any ideas?

<?php

include("include.php");

mysql_connect($dbhost, $dbuser, $dbpass);
@mysql_select_db("$dbname");

$query = "SELECT * FROM kunden";

$result = mysql_query($query);

$numR = mysql_num_rows($result);

$arree = array();
$arree2 = array();
$arree3 = array();
$arree4 = array();
$arree5 = array();
$arree6 = array();

for($i=0;$i<$numR;$i++) {
$row = mysql_fetch_object($result);

$arree[$i] = $row->ID;	
$arree2[$i] = $row->anrede;
$arree3[$i] = $row->name1;
$arree4[$i] = $row->name2;
$arree5[$i] = $row->ort;
$arree6[$i] = $row->anmeldename;

}

$kram = join("\n", $arree);
$kram2 = join("\n", $arree2);
$kram3 = join("\n", $arree3);
$kram4 = join("\n", $arree4);
$kram5 = join("\n", $arree5);
$kram6 = join("\n", $arree6);

echo "&id=".$kram."&";	
echo "&anrede=".$kram2."&";
echo "&vorname=".$kram3."&";
echo "&nachname=".$kram4."&";
echo "&ort=".$kram5."&";
echo "&username=".$kram6."&";

?>

[MikeSnead]

Are you have a specific problem with the script? Not using arrays would probably make the script MORE complicated... and you shouldn't have memory issues with a small script like that.

[Drakla]

Another trivial way of improving memory usage is to implode (join) arrays back to the same variable as in your join you're left with the array in the arreee and the joined array in kram so

while ($row = mysql_fetch_object($result))
{
$arree[] = $row->ID;
$arree2[] = $row->anrede;
$arree3[] = $row->name1;
$arree4[] = $row->name2;
$arree5[] = $row->ort;
$arree6[] = $row->anmeldename;
}


$arree = join("\n", $arree);
$arree2 = join("\n", $arree2);
$arree3 = join("\n", $arree3);
$arree4 = join("\n", $arree4);
$arree5 = join("\n", $arree5);
$arree6 = join("\n", $arree6);

Would already halve your overhead