$query = "show variables like 'char%'"; $a = mysql_query($query); while($i = mysql_fetch_assoc($a)) $output .= "A : ".$i['variables']."
"; Returns: A : A : A : A : A : A : A :