Hi!
I am having a problem searching a fulltext field. I'm setting up a little code library
program for a few of us who work together. One field (TEXT) is "keywords" and it is
indexed as well as fulltext. I send a simple query via my form to the code below. The
connection is successfully made, and I attempt to match my little search (for the word
"short") contained in the variable $searchterms. However, I get back the message that
$peeky (below) is not a valid MySql resource. Can someone tell me what I am doing wrong?
Thanks so much!
Cheers!
-Warren
======= Errant Code follows ===========
$dbh=mysql_connect ("localhost", "something_here", "something_here") or die ('Connection
failed because: ' . mysql_error());
mysql_select_db ("thedatabase");
$peeky=MYSQL_QUERY("select MATCH(keywords) AGAINST \"$searchterms\" from CodeLib" );
$peek=mysql_fetch_array($peeky);
$howMany=$peek[0];
echo "<br>Howmany=$howMany" ;
=======================================
