Re: Returing multiple rows based on 2 criteria

[Barry Galbraith]

>when i use mysql_fetch_array

Call it over and over until it returns false, Then you have every row it returned.

while ($row = mysql_fetch_array($result)){
  $var1 = $row['column1'];
  $var2 = $row['column2'];
 // the loop will continue while there are more rows.
  // do something with the vars returned at each iteration
}

Good luck,
Barry.