mysql_select_db("ypeceb2m_files", $con); $query = "SELECT DISTINCT tags FROM files"; $result = mysql_query($query); $numRows = mysql_num_rows($result); while ($row = mysql_fetch_array($result)) { $tags = explode(', ', $row['tags']); foreach($tags as $a=>$b) { if($numRows > 8) { echo "$b "; } else { echo "$b "; } } }