what's wrong with this function (with mysql)?

[SZero]

Hi everyone, have a look at this custom function

function countcat($ccount){
$conn=mysql_connect($server,$dbuser,$dbpass);
$q="select * from linkslinks where catno='$ccount'";
$r=mysql_db_query($dbname,$q,$conn);
while($row=mysql_fetch_array($r)) {
print "List: " . $row[title];
}
} 

when I call for example (countcat(5)) it only prints "List: ", I tried (countcat('5')) also doesn't work.. the connection and query is correct cause when I write it like that

$conn=mysql_connect($server,$dbuser,$dbpass);
$q="select * from linkslinks where catno='$ccount'";
$r=mysql_db_query($dbname,$q,$conn);

while($row=mysql_fetch_array($r)) {
print "List: " . $row[title];
} 

it works fine.. wut am I missing? TY..

[Mindzai]

The variables $server, $dbuser, $dbpass do not exist in the function's scope. You either need to declare them as global, or else pass them in to the function as arguments (or explicitly declare them inside the function, but that's not helpful when you have lots of functions). A tip is to always develop with error_reporting set to the highest level (E_ALL | E_STRICT), it would have caught this error for you and saved you lots of time.

[SZero]

thank you.. i declared them in the function n it worked