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 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()); 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 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. Link to comment https://forums.phpfreaks.com/topic/270998-query-help-in-fucntion/#findComment-1394198 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.