Ending with a dot

[Anon]

Can't seem to figure out this one out...
I tried this, see below :

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

echo ("$row[Name]");

if ($row) {
echo (",");
} else {
echo (".");
}

}

I just want to display the results as

Name1, Name2, Name3, Name4.

the last record should end with a dot and not a comma. How does one know that the record is the last one in the array?
Can anyone please explain to me?

Thanks

[ace21]

$i=0;
while ($row=mysql_fetch_array($results)) {
if($i)
echo (",");

echo ("$row[Name]");
$i++;
}
echo (".");

try this, probably not the best way but it'll work.

Ace21

[Anon]

yes it works!
u mean there's another way? actually this piece of code is inside another while loop

echo ("<table border=1 width=\"100%\">\n");
while ($mainrow=mysql_fetch_array($mainresults)) {
echo ("<tr><td width=\"200\" valign=\"top\">$mainrow[mainName]</td></tr>\n");
$subresults = mysql_query("select * from $dbtable where catID=$mainrow[catID]");
echo ("<tr><td>");

$i=0;
while ($subrow=mysql_fetch_array($subresults)) {
if($i)
echo (",");
echo ("$subrow[subName]\n");
$i++;
}

echo (".");
echo ("</td></tr>");
}
echo ("</table>\n");

any optimization tips?
if not, then thanks a lot 🙂

[Anon]

Here are another few ways you could get those things comma delimited:

===============================
while($row = mysql_fetch_array($results)) {
$names .= "$row[Name], ";
}
$names = preg_replace(", $",".",$names);

echo $names;

OR

===============================
while($row = mysql_fetch_array($results)) {
$names[] = $row[Name];
}
$name_joined = join(",",$names);

echo $name_joined;

Thats all I can think up for now 😉

-JoshB