"; while($row = mysql_fetch_array($sql)) { if($row['name'] == $last_name) { $file_sql .= ","; $file_sql .= $row['rid']; } else { if($last_name != "") $file_sql .= "\n"; $file_sql .= $row['name']; $file_sql .= ";"; $file_sql .= $row['rid']; $last_name = $row['name']; } } $file_sql .= "\n"; echo $file_sql; ?>