mattm1712 Posted November 21, 2012 Share Posted November 21, 2012 if this is my function code function getleague($templeague,$company) { echo $templeague; $query = mysql_query("SELECT * FROM templeagues WHERE templeague='$templeague'"); $numrows = mysql_num_rows($query); If($numrows==1) { echo "found league<br>"; } else { echo "no league<br>"; } } i am returning the templeague, but am getting an error Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in/home/content/35/10014135/html/update/updatefunctions.php on line what wounld be causing this?? cheers matt Quote Link to comment https://forums.phpfreaks.com/topic/270998-query-help-in-fucntion/ Share on other sites More sharing options...
akphidelt2007 Posted November 21, 2012 Share Posted November 21, 2012 Have you established a connection to the database? Try $query = mysql_query("SELECT * FROM templeagues WHERE templeague='$templeague'") or die(mysql_error()); Quote Link to comment https://forums.phpfreaks.com/topic/270998-query-help-in-fucntion/#findComment-1394188 Share on other sites More sharing options...
mattm1712 Posted November 21, 2012 Author Share Posted November 21, 2012 if i use that it says 'MySQL server has gone away' but i cant understand why Quote Link to comment https://forums.phpfreaks.com/topic/270998-query-help-in-fucntion/#findComment-1394197 Share on other sites More sharing options...
mrMarcus Posted November 21, 2012 Share Posted November 21, 2012 Well, you must establish a connection to the database at some point. Your queries simply won't execute without one. "MySQL server has gone away" can be caused from a number of things. Quote Link to comment https://forums.phpfreaks.com/topic/270998-query-help-in-fucntion/#findComment-1394198 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.