[RESOLVED] Need Help to retrieve data with php mysql

[fandhie]

I need to retrieve data from a table to make a slideshow (using jquery).

normally the code is as follow :

      <?php 
      $banner=mysql_query("SELECT banner_file FROM tb_banner ORDER BY banner_id DESC");
      if(mysql_num_rows($tampil) > 0) { 
       $no=1; 
       while ($r=mysql_fetch_array($banner)){
      ?>
      <img src="banner/<?php echo "$r[banner_file]"; ?>" />
      <?php $no++; }  ?>
      <?php } else { echo "<img src=\"banner/banner.jpg\"  />";} ?>

if I have 5 dataa on the table, the results would be as follow :

<img src="banner/banner01.jpg" />
<img src="banner/banner02.jpg" />
<img src="banner/banner03.jpg" />
<img src="banner/banner04.jpg" />
<img src="banner/banner05.jpg" />

but I need to add a class variable on the first image as follow :

<img src="banner/banner01.jpg" class="active" />
<img src="banner/banner02.jpg" />
<img src="banner/banner03.jpg" />
<img src="banner/banner04.jpg" />
<img src="banner/banner05.jpg" />

how to make it? anyone can help?

[Krik]

<?php
$banner=mysql_query("SELECT banner_file FROM tb_banner ORDER BY banner_id DESC");
if(mysql_num_rows($tampil) > 0) {
	$no=1;
	while ($r=mysql_fetch_array($banner)){
?>
		<img src="banner/<?php echo "$r[banner_file]"; ?>" <?php echo ($no == '1') ? 'class="active"' : ''; ?> />
<?php 
		$no++;
	}
}
else {
	echo "<img src=\"banner/banner.jpg\"  />";
} 
?>

[fandhie]

oww... thank you so much kirk....