While loops

[phily245]

Hi,

 

I'm writing a function that returns image locations from a database to show in a header jQuery slideshow, so that the user can edit what images are used, via his administration panel. However, for the jQuery to work, it needs to have the first image as the active class and all the others without a class. This is the function that I have so far:

function headerReturnImages() {

$query = mysql_query("SELECT image_image FROM reviews ORDER BY image_id ASC");

      while ($fetch = mysql_fetch_array($query)) {
      echo'<img src="images/';
      echo $fetch["image_image"];
      echo '" alt="" />';
      }
}

 

This outputs:

<img src="images/img1.jpg" alt="" />

 

however, I can't seem to find a way to make it output the following code on only the first image:

<img src="images/img1.jpg" alt="" class="active"/>

 

[fugix]

function headerReturnImages() {

$query = mysql_query("SELECT image_image FROM reviews ORDER BY image_id ASC");

      while ($fetch = mysql_fetch_array($query)) {
      if($fetch[0])
      {
      echo'<img src="images/';
      echo $fetch["image_image"];
      echo '" alt="" class="active" />';
      }
      else
      {
      echo'<img src="images/';
      echo $fetch["image_image"];
      echo '" alt="" />';
      }
   }
}

[phily245]

Thank, that solved it