[Resolved] variable output fits

[cjgdesign]

To anyone who can help... Many thanks a head of time!

I am trying to pull variables from a database, and if there is more than one entry, I want to echo the variables with a comma between them, but leaving it off of the last one.

If I did a select all and I had four entries, this is how I'd like them to look once I echo them to the screen:

variable one, variable two, variable three, variable four

Is this possible?

Thanks again for the help.

[barand]

Assuming the variables are in separate rows:

$vararray = array();
$res = mysql_query("SELECT varname FROM mytable WHERE .... ");
while ($row = mysql_fetch_row($res)) {
   $vararray[] = $row[0];
}

echo join(',' , $vararray);

hth