Hello Franky,

events signed as “draft” are shown in search result. Is it possible that they don’t appear in the results?

Here is my code (http://www.e-dynamics.be/bbpress/topic.php?id=223#post-1056):

<?php

$table = $wpdb->prefix.”dbem_events”;

$s = mysql_real_escape_string($_REQUEST); // The search key words

$found_event = false;

$query = “SELECT * FROM $table WHERE (event_name LIKE ‘%”.$s.”%’) OR

(event_notes LIKE ‘%”.$s.”%’) ORDER BY event_start_date”;

$events = $wpdb->get_results ( $query, ARRAY_A );

print “<div id=’archivebox-events’><h2 class=’silver’>Search results in events</h2></div>”;

foreach ($events as $row) {

print “<div class=’post-alt-events blog’><h3>“.$row.” / “.$row.”</h3>”;

print substr($row,0,250).” …
<span class=’continue’>read more</span>“;

print “</div>”;

print “<div style=’clear:both;’></div>”;

$found_event = true;

}

?>

Thanks a lot.