[Resolved] WHILE help

[xarnet]

Let's say for example this is my code:

<?php
$query = @mysql_query("SELECT * FROM table WHERE something = '$something'");
if (mysql_num_rows($query) > 0) {
	while ($data = @mysql_fetch_object($query)) {
	?>
?><b><?=$data->columnname?></b><?php
	}
}
else {
?>N/A<?php
}
?>

Now if there were two rows that something = $something, then I would end up with the data from columnname of the first row displayed followed directly by the data from columname of the 2nd row. So for example:

1st row -> hello
2nd row -> goodbye

Would show: hellogoodbye (both in bold).

But is there a way to get it to show hello, goodbye, but in the event there is only one row it would only show hello

Any help on this issue would be greatly appreciated and I thank you in advance for your time.

[LordShryku]

If I understand you, you just wanna comma in between results only if there is more than one result? This should do that...

<?
$query = mysql_query("SELECT * 
                      FROM table 
                      WHERE something = '".$something."'");

if(mysql_num_rows($query) > 0) {
    $i=0;
    echo "<b>";
    while($data = mysql_fetch_array($query)) {
        if($i==0) {
            echo $data['something'];
        }
        else {
            echo ", ".$data['something'];
        }
        $i++;
    }
    echo "</b>";
}
else {
    echo "N/A";
}
?>

[xarnet]

That's exactly what I wanted, thanks ^_