populate array from a data..

[jeepin81]

Ok - I think I might be over thinking this and I am little lost. I've done some google searching and I am at a loss.

I want to be able to populate an array with info from my database and then use that array later in my code. I can echo out to a page just fine but I am not sure how to get the info out of the database into an array for later use???

Here is the code I that works fine to echo out to a HTML page

<?php
//this script handles getting the array setup
// for the question numbers being asked and 
// putting them into an array to be used later in a different script.


$i5db2 = db2_connect("bob", 
                     "lob",
                     "law",
                     array("i5_lib"=>"files")) 
                     or die("Connect error: " . db2_conn_errormsg());


  // my query to get questions for vendor
  $sqlStatment = "SELECT NNUM FROM FILES.NIITEM WHERE NITEM = 'R130-2009' ORDER BY NNUM ASC";   

$stmt = db2_prepare($i5db2, $sqlStatment) 
                    or die("Prepare error: " . db2_stmt_errormsg());
$result = db2_exec($i5db2, $sqlStatment) 
                    or die("Execute error: " . db2_stmt_errormsg());

$test = 0;
$count = 1;

while ($row = db2_fetch_assoc($result)) {
  $test =  $row['NNUM'];
  echo "\"NQ$count\" => \"$test\",";
  echo "<br />";
  $count++;

  }

while($count <= 25){
echo "\"NQ$count\" => \"0\", "; 
echo "<br />";
$count++;
} 					
?>

How would I populate this array the same way so I can use it in a script later down the process?

I appreciate any help with this.

Thanks,
j

[jeepin81]

ps: here is the array written out that I am trying to create from my database so I can use it later. $NQ.... are the variables that are going to change. Basically I have a control file w/ 400+ numbered questions, which someone will be able to select upto 25 of those questions for a vendor to answer and I need to populate this array with the questions asked for the corresponding vendor.

<?PHP 

                                   $inparms = array("VNDR" => "$NVNDR",
			   "NITEM" => "$NITEM",
			   "NQ1" => "$NQ1",
			   "NQ2" => "$NQ2",
			   "NQ3" => "$NQ3",
			   "NQ4" => "$NQ4",
			   "NQ5" => "$NQ5",
			   "NQ6" => "$NQ6",
			   "NQ7" => "$NQ7",
			   "NQ8" => "$NQ8",
			   "NQ9" => "$NQ9",
			   "NQ10" => "$NQ10",
			   "NQ11" => "$NQ11",
			   "NQ12" => "$NQ12",
			   "NQ13" => "$NQ13",
			   "NQ14" => "$NQ14",
			   "NQ15" => "$NQ15",
			   "NQ16" => "$NQ16",
			   "NQ17" => "$NQ17",
			   "NQ18" => "$NQ18",
			   "NQ19" => "$NQ19",
			   "NQ20" => "$NQ20",
			   "NQ21" => "$NQ21",
			   "NQ22" => "$NQ22",
			   "NQ23" => "$NQ23",
			   "NQ24" => "$NQ24",
			   "NQ25" => "$NQ25" 
			    );?>

forgot to add that before

[bpat1434]

You could just do:

$count=1;
$inparams = array();
while ($row = db2_fetch_assoc($result)) {
    $inparams['NQ'.$count++] = $row['NNUM'];
}

while($count <= 25) {
    $inparams['NQ'.$count++] = '0';
}

print_r($inparams);