How to Loop through a recordset with a counter

I am totally new to php, and after hours cannot figure this out.
I have this code (sample #1) to get a recordset that has one column, and loop through it. It work find
My problem is that I must build a moving average based on the values in the recordset.  Do do so, I want to loop through the recordset using a counter like in Sample #2

 
Sample #1
$rsMA = odbc_exec($conn,$sql);
while($row = odbc_fetch_array($rsMA))
{echo $row['Close'];}
Sample #2
for($i=1; $i < 200; $i++) {
  	echo $row[$1];
}

Open in new window

rrhandle8Asked:
Who is Participating?
 
spoxoxConnect With a Mentor Commented:
Yes; sorry, didn't pay attention to that. The mysql_* stuff is particular to MySQL. Just replace it with the appropriate ODBC stuff, something like the attached snippet.
//something like this SQL:
$sql = "select Close, anAmount from someTable";
 
$rsMA = odbc_exec($conn,$sql);
 
$count = 0;
$tally = 0;
 
while($row = odbc_fetch_array($rsMA)) {
  echo $row['Close'];
  $count++;  // will count each row
  $tally += $row["anAmount"];  // will add up all anAmount fields
}

Open in new window

0
 
spoxoxCommented:
See $count and $tally in the snippet.
<?php 
//connect to MySQL
  $username = "eeuser";
  $password = "eepw";         
  $hostname = "localhost";
  $dbconn   = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
 
//connect to one MySQL database
  $database = mysql_select_db("eedatabase",$dbconn);
 
//text of the query to execute against the database 
  $query    = "SELECT aKey, aName, anAmount FROM aTable";
 
//execute the query, store the result set
  $result   = mysql_query($query) or die(mysql_error());
 
  $count = 0;
  $tally = 0;
//access all the data, one row at a time
  while ($row = mysql_fetch_array($result)) {
    echo $row["aKey"] . ' '. $row["aName"];
    $count++;  // will count each row
    $tally += $row["anAmount"];  // will add up all anAmount fields
    
  }
 
   mysql_close($dbconn);
?>

Open in new window

0
 
rrhandle8Author Commented:
ERROR:
Warning: mysql_fetch_array(): supplied resource is not a valid MySQL result resource

I am using ODBC to connect to an Access database.  Does that make a difference?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.