When I try to search with this, it doesnt return any results. Any ideas?
<html>
<head>
<title>HHS Scholarship Database :: Search</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);
if (isset ($_POST['submit'])){
if ($dbc = @mysql_connect('localhost', 'root', 'sqldb')){
if(!@mysql_select_db('scholarships')){
die('<p>Error:<b>' . mysql_error() . '</p>');
}
} else {
die('<p>Error:<b>' . mysql_error() . '</p>');
}
#Define the query
$query = "SELECT * FROM scholarships WHERE MATCH('{$_POST['select']}') AGAINST('{$_POST['criteria']}')";
if(@mysql_query($query)){
print '<p>Entry has been added<p>';
} else {
print '<p>Error: ' . mysql_error() . '</p>';
}
#Run the query we defined
if ($r = mysql_query ($query)) {
#Retreive all records and print the records
while ($row = mysql_fetch_array ($r)) {
print "<p><b>Award Title:</b> {$row['title']} </p>";
print "<p><b>Organization:</b> {$row['org']} </p>";
print "<p><b>Descrition:</b> {$row['descrition']} </p>";
print "<p><b>Eligibility</b>: {$row['eligibility']} </p>";
print "<p><b>Decision Criteria:</b> {$row['decision']} </p>";
print "<p><b>Award Minimum:</b> {$row['minimum']} </p>";
print "<p><b>Award Maximum:</b> {$row['maximum']} </p>";
print "<p><b>Deadline:</b> {$row['deadline']} </p>";
print "<p><b>Contact:</b> {$row['contact']} </p>";
print "<p><b>Address:</b> {$row['address']} </p>";
print "<p><b>Telephone:</b> {$row['phone']} </p>";
print "<p><b>Email:</b> <a href=\"mailto:{row['email']}\">{$row['email']}</a></p>";
print "<p><b>Web site:</b> <a href=\"{row['site']}\">{$row['site']}</a> </p>";
print "<p><a href=\"admin_edit.php?id={$row['id']}\">Edit</a> | <a href=\"admin_delete.php?id={$row['id']}\">Delete</a></p>";
print '<hr width="600" size="5" noshade>';
}
} else { #Query didn't run.
die ('<p>Could not retrieve data because: <b>' . mysql_error() . '</b></p>');
} #End of query IF.
mysql_close();
}
#Display the HTML Form Below
?>
<form action="search.php" method="post">
<table width="500" border="0" align="center">
<tr>
<td colspan="3"><div align="center"><strong>Search</strong></div></td>
</tr>
<tr>
<td width="164"><div align="center">By:
<select name="select" size="1">
<option value="title">Title</option>
<option value="org">Organization</option>
<option value="description">Description</option>
<option value="eligibility">Eligibility</option>
<option value="desicion">Decision</option>
<option value="minimum">Minimum Amount</option>
<option value="maximum">Maximum Amount</option>
</select>
</div></td>
<td width="256"><div align="center">Criteria:
<input name="criteria" type="text" id="criteria">
</div></td>
<td width="66"><div align="center">
<input type="submit" name="Submit" value="Submit">
</div></td>
</tr>
</table>
</form>
</body>
</html>