Remove comma from last result

[lbaxterl]

I have the following script which outputs different results based on weather a result is odd or even, pretty simple. The prblem lies with the very last result ouputted, as you can see from the code it will have a comma trailing it, which causes IE to not display the gallery.

 

Can Anyone advise me on how to remove this last comma/echo the last result differently.

 

Thank you

 

<?php
include "config.inc.php";
$num = 1;
function checkNum($num){
  return ($num%2) ? TRUE : FALSE;
}


	$result = mysql_query( "SELECT photo_id, photo_filename FROM gallery_photos WHERE photo_category= 6 AND promo= 1 ");
	$nr = mysql_num_rows( $result );

		$NumOfRecords = mysql_num_rows($result);

while($row = mysql_fetch_array($result)) {


  
  $id = $row['photo_id'];
  $img = $row['photo_filename'];
  
  
  if(checkNum($num) === TRUE){
   echo "
   
  { src: 'admin/photos/".$img."', dir: 'left'   },";
  
  $num++;

  }
  
elseif ($num == $NumOfRecords) {
      echo "  { src: 'admin/photos/".$img."', dir: 'left'   }";
   }


  
  else{
  echo  "
   
  { src: 'admin/photos/".$img."', dir: 'right'   },";
  $num++;
}

}

      ?>

[lbaxterl]

Sorry i posted code i was messing around with there here is the working code (in firefox at least), it still outputs the last record having a comma after it.

 

<?php
include "config.inc.php";
$num = 1;
function checkNum($num){
  return ($num%2) ? TRUE : FALSE;
}


	$result = mysql_query( "SELECT photo_id, photo_filename FROM gallery_photos WHERE photo_category= 6 AND promo= 1 ");
	$nr = mysql_num_rows( $result );

		$NumOfRecords = mysql_num_rows($result);

while($row = mysql_fetch_array($result)) {


  
  $id = $row['photo_id'];
  $img = $row['photo_filename'];
  
  
  if(checkNum($num) === TRUE){
   echo "
   
  { src: 'admin/photos/".$img."', dir: 'left'   },";
  
  $num++;

  }
  
  else{
  echo  "
   
  { src: 'admin/photos/".$img."', dir: 'right'   },";
  $num++;
}

}

      ?>

[iPixel]

use rtrim()...    $stringB =  rtrim($stringA,", ");

 

GOOD LUCK

[lbaxterl]

I'll look into this thank you!

[Jessica]

Or instead, put each value into an array, and when you're ready to echo it, use implode.

[Pikachu2000]

^^^ What she said. ^^^