Re: Shot in the dark
| From: | Chris Knipe | Date: | Mon, 17 Jun 2002 20:08:40 +0000 |
| Subject: | Re: Shot in the dark | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-102588@lists.php.net to get a copy of this message | ||
use something like
if (mysql_num_rows($news) > ) {
to see if mysql actually returned any data before you try to use the data in
PHP. A note of caution, mysql4.x is ALPHA... There may be allot of problems
with it still.
mysql_error() may also be a very handy function to you.
----- Original Message -----
From: "jtjohnston" <taylorjo@collegesherbrooke.qc.ca>
To: <php-general@lists.php.net>
Sent: Saturday, July 06, 2002 9:59 PM
Subject: [PHP] Shot in the dark
> 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
>
>