prefix . 'admin_user_message';
$table_users = $wpdb->prefix . 'users';
//$searchParam = "Ich";
if(isset($_POST['searchParam'])) {
$searchParam = $_POST['searchParam'];
$sqlSearchText = "SELECT * FROM $table_name WHERE message LIKE '%$searchParam%' OR subject LIKE '%$searchParam%'";
//echo $sqlSearchText;
$result = mysql_query($sqlSearchText);
$num_rows = mysql_num_rows($result);
//$error = "MySQL error ".mysql_errno().": ".mysql_error()."\n
When executing:
\$num_rows\n
";
//echo $error;
}
?>
= '1') {
echo $aum_term_quantity_message . ": " . $num_rows;
echo "
";
while($row = mysql_fetch_row($result)) {
echo "
";
echo $aum_term_subject . ": " . $row[7] . " ";
$querySender = "SELECT user_nicename FROM $table_users WHERE ID = '$row[1]'";
$resultSender = mysql_query($querySender);
while($rowSender = mysql_fetch_row($resultSender)) {
echo $aum_term_msg_from . ": ";
echo $rowSender[0];
}
echo "
";
echo substr ( $row[5] , 0, 300 ) . "...
";
//echo "Read more";
echo "
";
}
} else {
if(isset($_POST['searchParam'])) {
echo $aum_term_quantity_message . ": 0";
}
}
}
add_shortcode( 'admin_user_messages_search', 'admin_user_messages_search' );
?>