Last Foreach cicle, how to know?

[lopes_andre]

Hi,

 

I have a problem listing data from database.

 

I need to list data from a database and the results should be separated by ',', but I need a way to not show the ',' in the last cicle of the foreach.

 

My code is this:

 

<?php foreach ($result4 as $row4): ?>
<?php echo $row4->n_lingua ; ?>,
<?php endforeach; ?> 

 

The result of this is: "Portuguese, English,"

 

The question: How can I remove the last "," from the cicle?

 

 

Best Regards,

[wildteen88]

You may want to use implode instead.

<?php
foreach ($result4 as $row4)
    $rows[] = $row4->n_lingua;

echo implode(',', $rows);
?>

[lopes_andre]

Thanks for the reply,

 

It should return "Ingles, Espanhol, Portugues" but is returning "Ingles Ingles, Espanhol Ingles, Espanhol, Portugues"

 

The code is:

 

      
<?php foreach ($result4 as $row4): ?>
<?php $rows[] = $row4->n_lingua ;  ?>
<?php echo implode(', ', $rows); ?>
<?php endforeach; ?>

 

What should be wrong here?

 

 

Best Regards,

[lopes_andre]

Sorry,

 

It is working now:

 

      <?php foreach ($result4 as $row4): ?>
      <?php $rows[] = $row4->n_lingua ;  ?>
      <?php endforeach; ?>
      <?php echo implode(', ', $rows); ?>

 

 

Thanks for the help.

 

Best Regards,

[teamatomic]

Is the foreach you showed us nested inside another foreach? if so eliminate the nested foreach and use the implode on the $resultX.

 

 

HTH

Teamatomic

[dpacmittal]

Thats a nice way.

I always do:

preg_match('!(.*),!', $text, $matches);

$text = $matches[1];

 

I'll keep this method in mind too.