Can someone tell me why, when I call this function with "checkUserDb($user);" it's not returning anything for $matched ?
Am I missing something, because it makes no sense to me.


function checkUserDb($submittedName) {
    global $hostname, $username, $password, $dbName;

    if (!($connection = @ mysql_connect($hostname,$username,$password))) {
        die("Could not connect to host.");
    }

    if (!(mysql_select_db($dbName, $connection))) {
        die("Could not connect to database.");
    }

    $nameQuery = mysql_query("SELECT * FROM db_users");
    while ($checkRow = mysql_fetch_array($nameQuery)) {
        $formName = $checkRow['user'];
        if ($submittedName == $formName) {
            $matched = "yes";
            break;
        }
        else {
            $matched = "no";
        }
    }

    mysql_close($connection);
}


If only stupidity was painful...

If stupidity was painful, I'd be doing a lot of screaming. I was attempting to call the function, not check the result against anything. When I used everything worked fine.

For all the other newbs out there :D



If only stupidity was painful...

You are also missing a return statement in your function -- technically, your assignment statement ($match = checkUserDB($user)) shouldn't assign anything because checkUserDB() doesn't return anything...

I can only assume that the last line of your function is now:

  return $matched;


Take care,

Nik
http://www.bigaction.org/