Use an array more than once in a page...

[Spudgun]

Hi - pretty sure I'm missing something very simple here...
In my code, I'm running a query over an MSSQL table and pulling out catalogue sections:
e.g.
Section number: 101
Section Name: Banana Trees
Section number: 102
Section Name: Apple Trees

I've populated an array with this:
$data = array("101"=>"Banana Trees","102"=>"Apple Trees");

In my html, I have a form with a number of drop downs. The drop down lists contain the same data - from the array. So doing a while loop over the array I can populate the select list. However, if trying to do that multiple times, the first select box gets populated, but subsequent ones are empty. Its almost like once you have referenced or used an array once, you cannot re-use it.

Does any one have any ideas on where I'm going wrong ?

Code Snippet below:

$prwebc = " select distinct catnum,catsec from database.dbo.catalogues where cat='UKJF'";
      $prwebcres = mssql_query($prwebc);
	  For($aa=0; $r=mssql_fetch_row($prwebcres); ++$aa)
	 {
	  $prwebclist[$r[0]] = $r[1];
	}
	asort($prwebclist);

Then, in my HTML form:

    $query = " SELECT  *   FROM [DATABASE].[dbo].[CATALOGUE] where prcono='01' and PRODUCT in  ('".$sql_list."') and cat='UKJF' ";
	$queryres = mssql_query($query);
	print("<table border=2>");
	for($ax=0; $ar=mssql_fetch_row($queryres); ++$ax)
	{
	  print("<tr>");
                   print("<td>$ar[0]</td>");
                   print("<td>$ar[1]</td>");
                   print("<td>$ar[3]&nbsp$ar[4]</td>");
	  print("<td><select name=\"PRWEBC\">");
	  while(list($k,$v)=each($prwebclist[$ax]))
	  {
	    print("<option value=$k");
	    if($k==$ar[8])
		{
		  print(" SELECTED ");
		}
	    print(">$v");
	  }
	 print("</option></select></td>");
	 print("<td>$ar[9]</td><td>$ar[10]</td><td>$ar[11]</td><td>$ar[12]</td><td>$ar[13]</td><td>$ar[14]</td><td>$ar[15]</td><td>$ar[16]</td><td>$ar[17]</td></tr>");
	}
	print("</table>");

There are 26 rows in the output which should create 26 drop down lists containing data from the array.

[Masna]

I have no idea why, but while loops only run through once (on the same information). I've encountered this problem frequently recently. Use a foreach() loop instead.

[thepeccavi]

my personal preference is the while() loop, try different loops and see what happens...

[Rodney_H_]

Why not loop through the value once from the database and assign those values to a new array.

Then, you can use the values in that array in your page as many times as you like.

[laserlight]

I have no idea why, but while loops only run through once (on the same information). I've encountered this problem frequently recently. Use a foreach() loop instead.

No they dont. While loops iterate as long as the condition holds true. It is foreach loops that run through the array once.

my personal preference is the while() loop

My personal preference is to use the loop that makes sense in the given situation.

The first one should be:

$query = "select distinct catnum,catsec from database.dbo.catalogues where cat='UKJF'";
$result = mssql_query($query);
while ($row = mssql_fetch_row($result))
{
	$prwebclist[$row[0]] = $row[1];
}
asort($prwebclist);

I use a while loop since you want to loop as long as there is a row to retrieve from the result set.

The second one should be:

$query = "SELECT * FROM [DATABASE].[dbo].[CATALOGUE] where prcono='01' and PRODUCT in  ('".$sql_list."') and cat='UKJF'";
$queryres = mssql_query($query);
print "<table border=2>";
while ($row = mssql_fetch_row($queryres))
{
	echo "<tr>"
		. "<td>$row[0]</td>"
		. "<td>$row[1]</td>"
		. "<td>$row[3]&nbsp;$row[4]</td>"
		. "<td><select name=\"PRWEBC\">";

foreach ($prwebclist as $key => $value)
{
	echo "<option value=$key";
	if ($key == $row[8])
	{
		echo " SELECTED ";
	}
	echo ">$v</option>";
}
echo "</select></td>";
for ($i = 9; $i <= 17; ++$i)
{
	echo "<td>" . $row[$i] . "</td>";
}
echo "</tr>";
}

Again, the outer loop is a while loop as you want to loop as long as there is a row to retrieve from the result set. The first inner loop is a foreach loop since you want to iterate over an associative array. The second inner loop is a for loop since you want to iterate over a sequence of numbers.

[Masna]

Laserlight, I think you misunderstood me. When I said it only runs through once, I meant...

$result = mysql_query("SELECT * FROM `table`");
while($row = mysql_fetch_assoc($result)){
//w/e
}
////////////////////////////////////
while($row = mysql_fetch_assoc($result)){
//w/e
}

The second while loop will not run through, merely the first.

[Installer]

The second while loop will not run through, merely the first.

mysql_data_seek() will fix that.