News filing

[rofl90]

I'm creating a filing system for my news management, but when somebody picks more than one it will loop 'cat1, cat2, cat3,'

 

How do I get the last one to go 'cat4'

 

Thx

[benjaminbeazy]

please provide better explanation and/or code

[rofl90]

eg:

 

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

echo $row['category'];

echo ", ";

}

 

If theres say, 3 categories chosen i want it to display as

 

cat1, cat2, cat3.

 

But it displays as

 

cat1, cat2, cat3,

[cooldude832]

are you talking about the trailing comma?

the trick to this is

<?php
$q_count = mysql_num_rows($result);
$i = 1;
while($row = mysql_fetch_array($result)) {
echo $row['category'];
if($i < $q_count){
echo ", ";
}
$i++;
}
?>

[rofl90]

Ahh, why didn't I think of that, thankyou