Hi, I have used the above code created by NogDog (and below):

<html lang='en'>
<META HTTP-EQUIV='Content-Type' CONTENT='text/html; charset=ISO-8859-1'>
<title>Page title</title>
<style type="text/css">
table {
border-collapse: collapse;
border: solid 1px black;
td {
padding: 2px 6px;
border: solid 1px black;
<form action='<?php echo $_SERVER['PHP_SELF']; ?>' method='post'>
<p>Search for: <input type='text' name='search' size='20' maxlength='64'></p>
<p><input type='submit' value='Search'></p>
$connx = mysql_connect('localhost', '*****', '*****') or die("connx");
$db = mysql_select_db('test') or die(mysql_error());
# convert to upper case, trim it, and replace spaces with "|":
$search = (ini_get('magic_quotes_gpc')) ? stripslashes($_POST['search']) :
$search = mysql_real_escape_string($search);
$search = strtoupper(preg_replace('/\s+/', '|', trim($_POST['search'])));
# create a MySQL REGEXP for the search:
$regexp = "REGEXP '[[:<:]]($search)[[:>:]]'";
$query = "SELECT * FROM `users` WHERE UPPER(`description`) $regexp OR ".
"`name` $regexp";
$result = mysql_query($query) or die($query . " - " . mysql_error());
echo "<table>\n";
while($row = mysql_fetch_assoc($result))
echo "<tr>";
foreach($row as $key => $value)
echo "<td>$value</td>";
echo "</tr>\n";

Add my database and its working fine. Anyway I want to change some of the options. Right now it say:
echo "<td>$value</td>";

Is it possible to change it so it just take out the infomations from the string that I want show? Means right now it shows everything in the string, but I only want the search to show the "Name" and "Description" from the string and not all the other info that is saved in the string like "adresse","phonenumber", "staff" and so on....

Is the above codes the right to use og should I use something else?

Please advice - THANKS