ohdang888 Posted May 5, 2009 Share Posted May 5, 2009 I have a table called "test_table" with a few columns.... id, name, description, author I made name and description FULLTEXT fields so i could use MATCH AGINST searching with them i inserted multiple rows with random content, and one row with a name of php.net and description of "has lots of php stuff" here's my query: $res = mysql_query("SELECT *, MATCH(description, name) AGAINST('php') AS score FROM test_table WHERE MATCH(description, name) AGAINST('php') ORDER BY SCORE DESC")or die(mysql_error()); echo mysql_num_rows($res); theres no errors. And its echoing a zero. Whats up? Any ideas? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/156983-query-stuff/ Share on other sites More sharing options...
Yesideez Posted May 5, 2009 Share Posted May 5, 2009 Does the change in color in your post signify anything? Quote Link to comment https://forums.phpfreaks.com/topic/156983-query-stuff/#findComment-826927 Share on other sites More sharing options...
Ken2k7 Posted May 5, 2009 Share Posted May 5, 2009 WHERE MATCH(description, name) AGAINST('php') ??? Quote Link to comment https://forums.phpfreaks.com/topic/156983-query-stuff/#findComment-826939 Share on other sites More sharing options...
ohdang888 Posted May 5, 2009 Author Share Posted May 5, 2009 Does the change in color in your post signify anything? no..... WHERE MATCH(description, name) AGAINST('php') ??? ya its a nice mysql searching feature...read about it here: http://devzone.zend.com/node/view/id/1304 Quote Link to comment https://forums.phpfreaks.com/topic/156983-query-stuff/#findComment-826960 Share on other sites More sharing options...
ohdang888 Posted May 6, 2009 Author Share Posted May 6, 2009 bump Quote Link to comment https://forums.phpfreaks.com/topic/156983-query-stuff/#findComment-828010 Share on other sites More sharing options...
premiso Posted May 6, 2009 Share Posted May 6, 2009 Please do not bump after an hour. Perhaps if you took care and posted this in the MySQL forum you would of had your questioned answered by the MySQL gurus who tend to only browse that forum. Moving to MySQL forum. Edit: Sorry about the bump remarks, long day. Still the same goes, take care to choose the right forum for the topic. That is most likely why this has gone unanswered like it has. Quote Link to comment https://forums.phpfreaks.com/topic/156983-query-stuff/#findComment-828033 Share on other sites More sharing options...
Ken2k7 Posted May 6, 2009 Share Posted May 6, 2009 Please do not bump after an hour. Perhaps if you took care and posted this in the MySQL forum you would of had your questioned answered by the MySQL gurus who tend to only browse that forum. Moving to MySQL forum. Uh... check you time math premiso. I know you are good at it with your parentheses. Quote Link to comment https://forums.phpfreaks.com/topic/156983-query-stuff/#findComment-828035 Share on other sites More sharing options...
ohdang888 Posted May 7, 2009 Author Share Posted May 7, 2009 anyone? please. Quote Link to comment https://forums.phpfreaks.com/topic/156983-query-stuff/#findComment-828161 Share on other sites More sharing options...
fenway Posted May 7, 2009 Share Posted May 7, 2009 FULLTEXT is funny,... doesn't always match/return what you'd expect. Quote Link to comment https://forums.phpfreaks.com/topic/156983-query-stuff/#findComment-828729 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.