<?
/********************************\
#Metal Search v1.0
\********************************/
include ("config.php");
IF ($Choice == "Artist")
{
$VER="1.0"
$date = Date("F d, Y");
$keyword = $_GET['query']
$db_connection = mysql_connect ($DB_HOST, $DB_USER, $DB_PASS) or die ('Could not connect to MySQL: ' . mysql_error());
mysql_select_db ($DB_NAME) or die ('Could not select database: ' . mysql_error());
$query = "SELECT Name, Address, Description, Keywords FROM SSearch_Artist";
$results = mysql_query ($query) or die (mysql_error());
echo "<HTML>\n";
echo "<HEAD>\n";
echo "<TITLE>Results for $keyword</TITLE>\n";
echo "</HEAD>\n";
echo "<BODY BGCOLOR=\"#000000\" TEXT=\"$FFFFFF\" LINK=\"#66CCFF\" VLINK=\"#66CCFF\" ALINK=\"#66CCFF\">\n";
echo "<FONT FACE=\"Verdana\" SIZE=\"2\">\n";
echo "<H1>Search Result(s) for: query</H1>\n";
while ($row = mysql_fetch_array ($results, MYSQL_ASSOC)) {
echo "<A HREF=\"$row['address']\">$row['Name']</A> - $row['Description']<br />\n";
}
mysql_query("INSERT INTO SSearch_log (Date, Keyword, Choice) VALUES ($date, $keyword, $Choice);");
mysql_free_result($results);
mysql_close()
echo "<BR><BR><CENTER>Metal Search<BR>\n";
echo "$VER</CENTER>\n";
echo "</BODY>\n";
echo "</HTML>\n";
}
There is the first part rewritten into code that should work. You can use it for ideas on how to fix up the rest of the script.
Chris :)