Simple While Loop Question

Hello,

Im running a loop pulling in data from a SQL query seen below:

<?php while ($row7 = mysql_fetch_array($result7)){ echo $row7['COUNT(Category)'] . ','; } ?>

I need to have my data to print out, comma delimited.

0,23,42,53,5,2,4 etc BUT with this syntax, im getting one last comma at the end 5,3,6,3,6, that is messing up my data. how can I ommit the last comma from the loop?

Thank you!!!!

 

You basically need to get the number of rows in the query.

$rows = mysql_num_rows($result7);

$count = 1;

while ($row7 = mysql_fetch_array($result7)){

echo $row7['COUNT(Category)'] . ($count < $rows) ? ',' : '' ;

$count++;
}

PHP:

You can break this out of shorthand if needed as well.

 

How about using implode. Then just echo as your doing but remove your comma, see below, not tested.

$row7 = implode(",", $result7);
echo $row7['COUNT(Category)'];

Code (markup):

 

Many solutions to this.You could even preg_replace("/\,$/is","",$mysqlResult); meaning that if it sees the last character as a , it will replace it with an empty string

 

I prefer simpler solution

<?php
$data = "";
while ($row7 = mysql_fetch_array($result7))
{
  $data = "," . $row7['COUNT(Category)']; 
}
$data = substr($data, 1);

PHP: