Query Help In Fucntion

[mattm1712]

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

[akphidelt2007]

Have you established a connection to the database? Try

 

$query = mysql_query("SELECT * FROM templeagues WHERE templeague='$templeague'") or die(mysql_error());

[mattm1712]

if i use that it says 'MySQL server has gone away' but i cant understand why

[mrMarcus]

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.