Re: alternatives?

Clay, That works! Thanks. $news = mysql_query("SELECT * FROM $table WHERE MATCH (AU) AGAINST ('.$au.' IN BOOLEAN MODE) order by AU desc"); Are there any other alternatives to "in boolean mode"? I tried this: http://www.mysql.com/doc/F/u/Fulltext_Search.html $news = mysql_query("SELECT * FROM $table WHERE MATCH (AU) AGAINST ('.$au.') order by AU desc"); But get this error: "Can't find FULLTEXT index matching the column list" John Loveless wrote: > Try this: > > $news = mysql_query("select * from $table where AU like '$au' order by AU > desc"); > > -Clay > > > From: jtjohnston <taylorjo@collegesherbrooke.qc.ca> > > Reply-To: jtjohnston@courrier.usherb.ca > > Date: Sat, 06 Jul 2002 16:08:16 -0400 > > To: php-general@lists.php.net > > Subject: Re: [PHP] Shot in the dark > > > > Rasmus, > > > > Warning: Supplied argument is not a valid MySQL result resource in c:\program > > files\easyphp\ccl_www\db1\index.html on line 45 > > You have an error in your SQL syntax near ' Margaret order by AU desc' at line > > 1 > > > > So it doesn't like my "," (comma) ? > > > > $au ="Atwood, Margaret"; > > $id ="1624"; > > > > #$news = mysql_query('select * from '.$table.' where id like > > '.$id.' order by > > AU desc'); > > $news = mysql_query('select * from '.$table.' where AU like > > '.$au.' order by > > AU desc'); > > #$news = mysql_query('SELECT * FROM '.$table.' WHERE MATCH (AU) AGAINST > > ('.$au.' IN BOOLEAN MODE) order by AU desc'); > > > > while ($mydata = mysql_fetch_object($news)) > > { > > $mycounter++; > > echo $mydata->id." - ".$mydata->AU."<hr>"; > > } > > > > if(!$news) die(mysql_error()); > > > > > > > > > > Lerdorf wrote: > > > >> If you added some error-checking you'd know right away. > >> > >> ie. after your mysql_query() call. > >> > >> if(!$news) die(mysql_error()); > >> > >> -Rasmus > >> > >> On Sat, 6 Jul 2002, jtjohnston wrote: > >> > >>> MySQL4 installation. I don't get this. One mysql_query works, the other > >>> 2 don't. What did I mess up in my PHP syntax? > >>> The SQL queries all work. > >>> > >>> $au ="Atwood, Margaret"; > >>> $id ="1624"; > >>> > >>> THIS WORKS: > >>> $news = mysql_query('select * from '.$table.' where id like > >>> '.$id.' > >>> order by AU desc'); > >>> > >>> This gives "Warning: Supplied argument is not a valid MySQL result > >>> resource ... on line 48": > >>> $news = mysql_query('select * from '.$table.' where AU like > >>> '.$au.' > >>> order by AU desc'); > >>> #SQL-Query works: select * from ccl_main where AU like 'Atwood, > >>> Margaret' order by AU desc > >>> > >>> This gives "Warning: Supplied argument is not a valid MySQL result > >>> resource ... on line 48": > >>> $news = mysql_query('SELECT * FROM '.$table.' WHERE MATCH (AU) > >>> AGAINST > >>> ('.$au.' IN BOOLEAN MODE) order by AU desc`'); > >>> #SQL-Query works: SELECT * FROM ccl_main WHERE MATCH (AU) AGAINST > >>> ('Atwood, Margaret' IN BOOLEAN MODE) order by AU desc > >>> > >>> while ($mydata = mysql_fetch_object($news)) <----- this is line > >>> 48 > >>> { > >>> $mycounter++; > >>> echo $mydata->id." - ".$mydata->AU."<hr>"; > >>> } > >>> > >>> > >>> > >>> -- > >>> PHP General Mailing List (http://www.php.net/) > >>> To unsubscribe, visit: > >>> http://www.php.net/unsub.php > >>> > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > >