Menu
Community /Pin to ProfileBookmark
@NogDogDec 20.2005 — #Either <> or != should work. My best guess is either "prayerconcerns" or "person" is an invalid column name. Make sure they are spelled exactly as defined in the datbase, icluding upper or lower case letters. To get more indication as to where the problem is in the query, try:
(The '@' is suppressing error-reporting, so you need to check for errors yourself if you're going to use it.)
can’t get this query to run. please help
I have this code
$query = “SELECT * FROM prayerconcerns where prayerconcern <> ” order by person”;
$result = @mysql_query ($query);
$num_rows = mysql_num_rows ($result);
I get error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:Inetpubwwwrootprayerconcern.php on line 94
PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:Inetpubwwwrootprayerconcern.php on line 94
If I change query to this:
$query = “SELECT * FROM prayerconcerns order by person”;
It works ok.
I guess it has something to do with escaping the characters but I can’t get figure it out.
Thanks,
Rut
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogDec 20.2005 — #Either <> or != should work. My best guess is either "prayerconcerns" or "person" is an invalid column name. Make sure they are spelled exactly as defined in the datbase, icluding upper or lower case letters. To get more indication as to where the problem is in the query, try:[code=php]
$result = @mysql_query ($query) of die(mysql_error());
[/code](The '@' is suppressing error-reporting, so you need to check for errors yourself if you're going to use it.)