implode

An example of this would be to create a function called GetDistinctArray() which essentially returns an array generated from a query like
"SELECT DISTINCT $COLUMN FROM $TABLE".

Once you have an array say of distinct categories, implode lets you spit them out into a SELECT statement with:

echo '

<SELECT NAME="CATEGORY">';

$CATEGORY = "Foo";

$CatArray =
GetDistinctArray("CATEGORY",$DATABASE,$TABLE);

$OPTIONS = implode("<OPTION>",$CatArray);

echo '<SELECT NAME = "CATEGORY">';

print "<OPTION>$OPTIONS
</SELECT>";



The same could have been done by simply doing a query, looping through the array elements, but this is much cleaner and the function is reusable for any other dropdowns..