fulltext searching

iamjbrandt

Why does this not work?

<?php
mysql_connect ('localhost', 'cdn7', '********');
mysql_select_db ('cdn7_jared');

$query = mysql_query ("select `firstname`, `lastname`, `email`, match(`email`) against('hotmail') as `relevance` from `emails`");

while ($row = mysql_fetch_array ($query)) {
	echo $row['relevance'] . ' ' . $row['email'].'<br />';
}
?>

It returns:

http://www.cdn7.com/j.7/email_list

Someone please help! Thanks!

Jared

steadyguy

Is the column "email" a FULLTEXT column?

iamjbrandt

Yeah, everything is properly formatted.

steadyguy

Alright ... you never know; your query should work ...
mysql_error() can tell you why it's not working properly:

$query = mysql_query ("select `firstname`, `lastname`, `email`, match(`email`) against('hotmail') as `relevance` from `emails`")
if (mysql_error()) 
    print mysql_error();
else {
    //do your stuff
}