Here is what I got so far and it works! search.php
<form method="post" action="search_results.php">
<table width=88% align=center class="border_table">
<tr bgcolor="#55556F">
<td width="22%" bgcolor="#55556F"><p>Search for:</p></td>
<td width="78%"><input type=text name='search' size=60 maxlength=255></td></tr>
<tr bgcolor="#55556F"><td></td>
<td bgcolor="#55556F"><input type=submit></td>
</tr>
</table>
</form>
search_results.php
<?
include("****.php");
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die ("Problem connecting to Database");
$query = mysql_query("SELECT wname, url, title, keywords, description, city, country, category FROM directory WHERE city LIKE '%$search%' ¦¦ wname LIKE '%$search%' ¦¦ title LIKE '%$search%' ¦¦ keywords LIKE '%$search%' ¦¦ description LIKE '%$search%' ¦¦ country LIKE '%$search%' ¦¦ category LIKE '%$search%' ¦¦ url LIKE '%$search%'", $db);
if ($query)
{
echo "<table width=100% border=0 cellpadding=0 cellspacing=5 class=border_playlist_table><tr>";
while ($myrow = mysql_fetch_array($query)) { // Begin while
$wname = $myrow["wname"];
$url = $myrow["url"];
$title = $myrow["title"];
$city = $myrow["city"];
$country = $myrow["country"];
$category = $myrow["category"];
$keywords = $myrow["keywords"];
$description = $myrow["description"];
echo "<tr class=sub_1><td colspan=4>$wname : $category</td></tr>
<tr bgcolor=#55556F><td><p><a href=$url target=_blank>$url</a></p></td>
<td><p>$title</p></td>
<td><p>$city</p></td>
<td><p>$country</p></td></tr>
<tr bgcolor=#55556F><td colspan=4>$keywords</td></tr>
<tr bgcolor=#55556F><td colspan=4>$description</td></tr>
<tr><td colspan=4> </td></tr>";
} // end while
echo "</tr></table>";
} else { echo "problems...."; }
} else {
echo "Search string is empty. <br> Go back and type a string to search";
}
?>
Thanks for all your help!
~Shane
