Re: Shot in the dark

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 >