Not a valid result resource

mwdrago

Hello everyone, I have a problem here-

I'm getting this error:

Warning: Supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\member_directory\pages\edit_profile.php on line 132

from this code:

<? if (mysql_num_rows($result) == 0){ ?>

please go easy on me I'm very tired and I'm pretty new to PHP(hence posting in this forum. Can someone tell me what I'm doing incorrectly? I could swear this page was working when I originally created it, maybe I screwed with the settings?

Thanks!

volleytotal_ch

guess you're searching in a table. the result is saved in $result. with the function mysql_num_rows($result) you're counting how many rows are found in $result.
if you receive the error message you descriped, the query wasn't successfully! check the spelling of your query! (post it so that we can check it for you 😉 )
hth

mwdrago

wow, thanks for replying so quickly. Here is my query:

$sql = "SELECT * FROM tblinfo WHERE inffanclubno='$fanclubno'";

I'm basically trying to see if this is a user that hasn't supplied their info and populated this table yet. If there is no result then they're new and need to enter their info.

volleytotal_ch

can't see any error in your sql statement!
Can you submit content of your script with the query, the mysql_result-function? a guess it has something to do with your execution of the query (the mysql_result-function)

siwis

what is line 132 of your code?

The error tels you much that you can use to debug your code.

The error message you received is telkling you that you are attempting to do something with the results of your query which is invalid. There can be a variety of reasons.

Post your code here from the point at which you perform the query to a few lines after line 132

As a check beforehand, echo the sql to screen to ensure it is as you think it sould be. Is your database field name spelt correctly? etc etc

mwdrago

$sql = "SELECT * FROM tblinfo WHERE inffanclubno= '$fanclubno'";

$result = mysql_query($sql);

<? if (mysql_num_rows($result) == 0){ ?>

	<? } ?>

This is basically all the relevant code, I think. I don't want to paste the whole page and have this thread stretching down for eternity.
😃

siwis

Does the code you posted INCLUDE line 132 of your script??????

The mysql error message is invoked either at the point where you run the query or at the first point where you try to use the results.

The code you posted gives us no extra insight into the cause of your problem.
Post the lines additonal to your above code up to a point just after you call $var = mysql_fetch_row() or mysql_fetch_arry()

volleytotal_ch

how do you connect your database?
do you have a command "$db = mysql_connect()" somewhere?

then this line has to be modified:
$result = mysql_query($sql. $db);

in your script, mysql can't find the database (i guess)

mwdrago

ok, this might be confusing, but I echoed $sql and I got another SQL statement: "select * from tblLogin"..etc...
This is the code I think it used:

$sql = "SELECT * FROM tblinfo WHERE inffanclubno= '$fanclubno'";

$result = mysql_query($sql);

if(mysql_num_rows($result) == 0){
$sql = "select * from tblLogin where lgnFanclubNo='$fanclubno'";
$newuser_result = mysql_query($sql);
$yourinfo_array = mysql_fetch_array($newuser_result);

	$new_id = $yourinfo_array["lgnFanclubNo"];
	$type = $yourinfo_array["lgnType"];

}

so basically my code is saying that there is nothing in the Info table so it went to the Login table.

so when it gets to:
<? if (mysql_num_rows($result) == 0){ ?> on line 132, there is nothing in $result because there was no result from the original query.

The only thing is that I know that there should be one row returned!! I ran the query through phpmyadmin and it returned one row! I should also add that I'm passing the variable $fanclubno through the URL.

mwdrago

volleytotal.ch you solved my problem!

I feel so stupid!

I had commented out my includes because they have my session handling stuff which wouldn't let me link directly to this page without logging in.

My includes also have my database connection, rather than typing it out on every page!

So I wasn't connecting to the database! HAHAHAHA I feel so dumb.

I was looking for some difficult answer and it was the easiest one. Well thanks for helping me realize that! 😃

volleytotal_ch

do you have a line in your script similar to this one:

$db = mysql_connect("localhost", "user","password");

the variable $db (in this example) is needed to say where you want to search with your query:

$result = mysql_query($sql,$db);

see the $db which i added comparing to your code!