<?
function smilie($text) {
  
  $textresult = mysql_query("SELECT smilietext FROM smilies");
  $imageresult = mysql_query("SELECT smilie FROM smilies");
  $textrows = mysql_num_rows($textresult);
  
  for ($i = 0; $list = mysql_fetch_array($textresult); $i++) {
    $patterntext["$i"] = "/$list[smilietext]/";
  } 
  
  for ($i = 0; $list = mysql_fetch_array($imageresult); $i++) {
    $patternimage["$i"] = "<img src=\"" . $list[smilie] . "\">";
  } 
  
  if ($textrows > '0') {
    $text = preg_replace($patterntext, $patternimage, $text);
  } 

  return $text;
} 
?>