Re: Empty query result

Pablo,

Hello Philip,

    pse.. can you paste the error information?
    There is no known "empty set" problem.

Here's my function:

function getMysqlSelectResultForUsername($identifier, $userName, $link) {

    $queryResult = mysql_query("select $identifier from theTable where username = '$userName'", $link);

    if (!($queryResult = mysql_result($queryResult, 0))) {
        session_register('_selectIdentifierFromTheTable');
        header("location:error.php");
        exit;
    }

    return $queryResult;

} Here's the code that calls it: $hall = getMysqlSelectResultForUsername('buildingID', $_userName, $link); $roomNum = getMysqlSelectResultForUsername('roomNum', $_userName, $link); $phone1 = getMysqlSelectResultForUsername('phone1', $_userName, $link); $phone2 = getMysqlSelectResultForUsername('phone2', $_userName, $link); $lastLogin = getMysqlSelectResultForUsername('lastLogin', $_userName, $link); If the mysql_result($queryResult, 0) returns zero/nothing, then it goes to the 'error.php' page. However, I just want it to move on. For example, if there is no 'phone2' given in the database, I want it to just assign $phone2 to zero/nothing, not go to the error page. Hope this helps. Thanks, ~Philip

-- Best regards, Pablo PT> Hi all. PT> I am querying a database of single information multiple times using a PT> simple 'select' statement. However, whenever the data in the DB is PT> empty or is 0 (zero), then it throws an error. However, I don't want it PT> to throw an error, I just want it to move on to the next query. PT> This is being shown on a webpage I have. Note that I am using a PT> function for this select statement because I just have to change the PT> identifier that I am looking for - saves space. So I don't use PT> mysql_error() to show my errors, I redirect to a global 'error' page. PT> Is there a way to get around this "empty set" problem? Yes, I know PT> about using @ to suppress warnings, but it's more than this. PT> Thanks a bunch, PT> ~Philip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php