Seperating MySQL Data

[cheechm]

Hi,

Me again.

 

I do this:

 

                            while ($rowi = db_fetch_array($resulti)) {

                                echo $rowi['name'] .", ";
                            }

The comma shows on the last result as well. How can I stop that?

 

Thanks

[void]

some basic thinking ...

 

while ($rowi = db_fetch_array($resulti)) {

$names .= $rowi['name'] .", ";

}

echo substr($names,0,-2);

 

 

[cheechm]

Doesn't seem to work.

[Barand]

$names = array();
while ($rowi = db_fetch_array($resulti)) {
    $names[] = $rowi['name'];
}

echo join (', ', $names);

[cheechm]

That neither thanks!

[unkwntech]

$names = array();
while ($rowi = db_fetch_array($resulti)) {
    $names[] = $rowi['name'];
}

echo implode(', ', $names);

[cheechm]

Doesn't seem to work either. I will post a bigger code block:

 

                    $sqlc = "SELECT name FROM customers WHERE cid = " . $cid . "";
                    $resultc = db_query($sqlc) or die("MySQL ERROR: " . mysql_error());
                    while ($rowc = db_fetch_array($resultc)) {
                        if ($row['delivery']) {
                            $delivery = "<li>Delivery: Required</li>";
                        }

                        echo "<ul class=\"qrequestsf\">";
                        echo "<li>Quote ID: " . $qid . "</li><li>Customer: " . $rowc['name'] .
                            "</li><li>Notes: " . $row['notes'] . "</li><li>Last Action Taken: " . date('d/m/Y',
                            strtotime($row['date'])) . "</li><li>Date required: " . date('d/m/Y', strtotime
                            ($row['pdate'])) . "</li><li>Return Date: " . date('d/m/Y', strtotime($row['rdate'])) .
                            "</li>" . $delivery . "<li>Kit Required: ";

                        $item = split(', ', $row['items']);
                        $items = array_unique($item);
                        foreach ($items as $value) {
                            $sqli = "SELECT name FROM hire WHERE id = " . $value . "";
                            $resulti = db_query($sqli) or die("MySQL ERROR: " . mysql_error());
                            $names = array();
                            while ($rowi = db_fetch_array($resulti)) {

                               echo $rowi['name'] .", ";
                            }

                        }
                        echo "</li><li>Status: " . $status_is . "</ul>";

                    }