What does the error 'Warning: 1 is not a valid MySQL-Link resource' mean?
Jan 18th, 2002 16:43
Eric Benoit, James Moore, Matt Gregory, Joshua Ariizumi, Nathan Wallace,
This probably means that you are using a result index where an link
index is expected. Check your syntax.
example which gives this error: (assuming that MyDatabase exists)
$myconnection = mysql_connect("localhost", "user", "pass");
$Query = "SELECT * FROM MyDatabase";
$resultset = mysql_query($Query);
$numrowsaffected = mysql_affected_rows($resultset);
//this is wrong because mysql_affected_rows expects the link index
//not the result index. Fix the error by changin it to:
$numrowsaffected = mysql_affected_rows($myconnection);
Also, it is possible that the database you are referring to in your
connection string is wrong or your database is named differently to
what you refer to in your connection string.
You may also encounter this error (and I found out the hard way) when
your table doesn't have any index...took me awhile to figure this one
out at the time, wish I know about this site then! :)