[snip]
<p>Flies in pot = <?=flies();?> </p>
function flies(){
$sql = 'select count(*) from flies';
$lnk = mysql_connect('localhost','root','123456');
$db = mysql_select_db('moar',$lnk);
$result = mysql_query($sql,$lnk);
mysql_free_result($result);
mysql_close($lnk);
return $result;
}
Why this leads to 'resource id #10' instead of the flies count ?
[/snip]
Because $result is a resource in PHP, not the actual result of the
query;
function flies(){
$sql = 'select count(*) AS flyCount from flies';
$lnk = mysql_connect('localhost','root','123456');
$db = mysql_select_db('moar',$lnk);
$result = mysql_query($sql,$lnk);
$foo = mysql_num_rows($result);
mysql_free_result($result);
mysql_close($lnk);
return $foo;
}
http://www.php.net/mysql_num_rows
