<?php
if (!isset($_POST['submit'])) {
  echo "Blank box.  retry";
} else {
  $tag = $_POST['submit'];

  $location="localhost";
  $username="sj";
  $password="tc6859LNf8phSMBR";
  $database="sj_xbl";

  mysql_connect($location,$username,$password);
  mysql_select_db($database) or die( "Unable to select database");
  $qtag = mysql_real_escape_string($tag);

  $to_send = explode(" ", $qtag);
  unset ($result);
  foreach ($to_send as $send_item) {
    $result[] = search($send_item);
  }
  foreach ($result as $result_item) {
    foreach ($result_item as $result_item_item) {
      $final[] = $result_item_item;
    }
  }
  $result = $final;
  // DEBUG: Show all matching results.
  //print_r($result);

  // Output example:
  foreach ($result as $result_item) {
    echo "<a href=\"member.php?tag=".$result_item."\">".$result_item."</a>";
  }
}


  function search($stag) {
    $query="SELECT * FROM `members` WHERE `tag` LIKE '%$stag%'";
    $result=mysql_query($query);
    if(!$result) {
      die(mysql_error());
    }
    unset ($tag);
    while ($row = mysql_fetch_assoc($result)) {
      $tag[] = $row['tag'];
    }
  return $tag;
  }
?>