$query = $vbulletin->db->query_read(" SELECT field1 FROM " . TABLE_PREFIX . "mytable "); while($row = $vbulletin->db->fetch_array($query)){ $words = explode(',', $row['field1']); foreach($words as $word) { echo '<a href="myfile.php?do='. htmlspecialchars_uni($word) .'">'. htmlspecialchars_uni($word) .'</a>'; }}