Hi, does anyone know how to convert mysql arrays eg(row[0]) to a string value with separators in PHP. I am trying to get email info from a database to automate a mass mail out.

Cheers

Rob

assuming you are using a select statement:

$query = "Select * from sometable";
$query2 = mysql_query($query);

while ($row = mysql_fetch_array){
     foreach($row as $key=>$value){
         $string[].=$value .', ';
     }


}

----------------
Never bother to learn something not knowing which does not do you any harm, and never neglect to learn something whose negligence will increase your ignorance - Imam Jafar Sadeq

i just thought about this, this might be another alternative:

$query = "SELECT CONCAT(fieldname1, ', ', fieldname2,', ',fieldname3) AS fulltext FROM sometable ORDER BY fieldname1";

----------------
Never bother to learn something not knowing which does not do you any harm, and never neglect to learn something whose negligence will increase your ignorance - Imam Jafar Sadeq

Just use PHP function IMPLODE()

Yo