Add count to each result

[adzie]

 

Hello all,

 

I'm struggling adding a count result to this script.  I want each result to be an id so I can place x amountof images in one position and the remaining in another position.  Each user might have different awards so just using the award_id is no good as there will be empty space so I need the actual result to display a id number.

 

$res = mysql_query("SELECT award, image FROM awards WHERE active = '1'");


$codes = array();
while ($row = mysql_fetch_assoc($res)){
   $codes[$row['award']] = $row['image'];
}


$userid = '1';


$res = mysql_query("SELECT * FROM user_awards WHERE user_id = '$userid'");


$row = mysql_fetch_assoc($res);
foreach ($codes as $award => $image){
   if ($row[$award] == 1){
      echo "<img src=../$image><br/>";
   }
}

[adzie]

Sorry I should have maybe said I need a result id or count for the user_awards table and not the award table if that helps.

 

Best regards