function problem

[teddmcload]

i have a function in forum_func.php like

function cookiecheck() {
$cookiecheck = mysql_db_query($dbasename, "select memberid from members where memberid='".$_COOKIE[memberid]."'");
if (mysql_num_rows($cookiecheck) > 0) { // line 5
$checkresult = "1";
} else {
$checkresult = "0";
}

}

and i call this function from board.php. i call it like this

cookiecheck()
echo $checkresult;

but i returns

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\tumerportal\forum\forum_func.php on line 5

where is my fault

[OhLordy]

$dbasename is set outside the function. Therefore to use it within the function you must make it global. Add this line to the begining of the function
global $dbasename;
Also, you are setting a local variable $checkresult and then using it outside the function (this will not work) it may be easier to return true or false and perform your condition on the return value of the function.

<?php
if(mysql_num_rows($cookiecheck)>0) {
  return true;
} else {
  return false;
}
?>

then

<?php 
if(cookiecheck()) {
  echo("Cookie check passed");
} else {
  echo("Cookie check failed");
}
?>

HTH
Rob

[teddmcload]

it works. thank u 🙂