supplied argument is not a valid MySQL result resource

awesome_aims

Hi, i keep getting the error:
supplied argument is not a valid MySQL result resource
randomly in my mysql coding, I'm doing the statements correctly, like ive always done them, but recently when I type new mysql statements, i get that error when i load the page, im only getting it on the statements ive written recently, the ones already on that page work fine, i have concluded that there is no reason for this, its happening on everything from mysql_result() to mysql_numrows() to mysql_query(). Is there a problem with mysql on my server, could an update have caused this? It started 2 days ago, and since then I can't do any mysql, but the code that was previously on the pages works. I'm so cunfused. Can Some1 please help me?

devinemke

what does [man]mysql_error[/man] have to say about your query(s)?

laserlight

It is possible that the query failed, or that you failed to connect to the database server. Checking for these potential problems and gracefully handling them should be the way to go.

Incidentally, use mysql_num_rows() not mysql_numrows() as the latter is deprecated.

awesome_aims

awww man, i feel stupid, i added
or die(mysql_error()) to the queries and it turns out i thought those certain tables were in a different DB,
thanks for your help.

awesome_aims

No, im still getting that error on another page, the mysql error turned out to be:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'values WHERE type = '$rowval' at line 1
my query was:
SELECT * FROM values WHERE type = '$rowval'
i dont see why im all of a sudden getting these errors, im doing everything the same as ive always done them, i dont see anything wrong with the syntax.
note: I got the exact same error when i had type displayed 'type' and when i had values displayed 'values' (with quotes), and i had it when both were in quotes, has the syntax changed that drasticly? Please help me. my MySQL verison is 4.1.13

samudasu

Using "values" as a table name could create problems since values is a mysql keyword. Try changing the table name and see if it starts working.

Jef_Leeson

The same thing...???

I am using the following code:

$membernum=$GET['memid'];
$loginpassword=$GET['logpw'];

$user="webchef8_webchef";
$host="localhost";
$password="dbedit8";
$database = "webchef8_lgt";

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database, $connection)
or die ("Couldn't select database");

$query="SELECT * FROM contacts WHERE MEMID='$membernum'";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();

echo "$num";

$i=0;
while ($i < $num) {
$memid=mysql_result($result,$i,"memid");
//$lpw=mysql_result($result,$i,"logpw");

//Space For Code

++$i;
}

...and get the error. What am I coding incorrectly?