Help: formatting an array

[datona]

Can anyone tell me if it is possible to take an array and format it for HTML so there is a comma between each variable BUT for the last one, there is a 'AND'

In the MySQL database, the variable has:
Aerobics,Hunting,Walking,Hiking,Fishing

What I would like to do is take that from the database and format in the browser as:

The activities which I like to do are:
Aerobics, Hunting, Walking, Hiking and Fishing

• Please note the 'and' before 'Fishing'

That is what I am attempting to accomplish but I am not able to find any information on how to format in this fashion.

Any help would be greatly appreciated.
Thanks

[tsinka]

Hi,

if you already have an array containing theses variables than you can do something like this:

<?PHP
    // this array contains the values
    $arrValues = <fetch_the_db_values_to_an_array>;

$theString = "";

$cnt = count($arrValues);

for ($i=0;$i<count($arrValues);$i++) {
    $theString .= $arrValues[$i];

    $theString .= ($i == $cnt-2 ) ? "AND" : ($i < $cnt-2) ? "," : "";
}
?>

[datona]

tsinka, that works great BUT for some reason, it puts the commas in BUT not the 'and' before the last one.

<?
$arrValues=explode(",", $new_activities);
    $theString = "";
    $cnt = count($arrValues);
    for ($i=0;$i<count($arrValues);$i++) {
        $theString .= $arrValues[$i];
        $theString .= ($i == $cnt-2 ) ? "AND" : ($i < $cnt-2) ? "," : "";
    }
echo "$theString";

?>

Produces:

Aerobics,Camping,Skiing/Snowboarding,Water skiing,Jogging/running

Notice that the 'and' is not added BEFORE Jogging/running

[tsinka]

Hi,

this should solve the problem:

$theString .= ($i == $cnt-2 ) ? " AND " : (($i < $cnt-2) ? "," : "");

[datona]

tsinka, Thank you SO MUCH.
It is working great!