help me with my Full Text Search code
Posted: Tue Jan 06, 2004 10:13 am
Can anyone tell me is this the correct way to use the full text search??
but there seems to be something wrong..i keep getting the message
"Not Found".
but there seems to be something wrong..i keep getting the message
"Not Found".
Code: Select all
if (isset($_POSTї'searching'])) { // Handle the form.
// Add the user.
$query = "SELECT * FROM client WHERE MATCH (name) AGAINST ('$word');";
$result = mysql_query ($query);
$row = mysql_fetch_array($result);
if ($row) { // If it ran OK.
echo "Found {$rowї'name']}";
}
else { // If it did not run OK.
echo '<p><font color="red" size="+1">Not Found</font></p>';
}
} // End of the main Submit conditional.
print "<form action='$PHP_SELF?eid={$rowї'cacc']}' method='post'>";
echo "<b>Enter client's name:</b><input type="text" name="word" size="80"><br><br>";
print "<input type="submit" name="searching" value="Search">";
print "</form>";
mysql_close(); // Close the database connection.