[Boofo]

This is what I am using and I get a Query is empty error:

PHP Code:

<?php
require_once('./global.php');
$smilie_counts = array();
$posts = $DB_site->query("
  SELECT smilietext, pagetext 
  FROM post, smilie 
  WHERE pagetext like concat("%",smilie.smilietext,"%") 
");
while ($post = $DB_site->fetch_array($posts))
{
  $smilie_counts["$post[smilietext]"] += substr_count($post['pagetext'], $post['smilietext']);
}
echo "$smilie_counts";
?>