Re: Empty query result

Thanks all! I will try some of the suggestions that you guys gave. I appreciate it. ~Philip On Jul 26, 2004, at 12:52 PM, Pablo M. Rivas wrote:

Hello Philip,

      read:
      http://www.php.net/manual/en/function.mysql-result.php

      when you do $queryResult = mysql_result($queryResult,0) you get
      the error... so, you can do something like this:

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

      $queryResult = mysql_query("select $identifier from theTable where

username = '$userName'", $link);

      if ($queryResult) {
         $queryResult = mysql_result($queryResult, 0);
      }
      return $queryResult;

}

     $hall = getMysqlSelectResultForUserName('buildingID', $_userName,$link);
     if (!$hall) die ("error")
     ....

or you can do:

      function getMySqlSelectResultForUserName($identifier,
      $userName,$link) {
           return mysql_query("select $identifier from TheTable where
           username='$userName'",$link);
       }

$hall= getMysqlSelectResultForUsername('buildingID', $_userName, $link); if (!$hall) die("not found building!!!"); $roomNum = getMysqlSelectResultForUsername('roomNum', $_userName,$link); $phone1 = getMysqlSelectResultForUsername('phone1', $_userName, $link); $phone2 = getMysqlSelectResultForUsername('phone2', $_userName, $link); $lastLogin = getMysqlSelectResultForUsername('lastLogin', $_userName,$link);

      if ((!$roomNum) or (!$phone1) or (!$phone2) or (!$lastLogin)) {
         echo "data is missing";
         .... ....
      } else {
         .......
      }

PT> Pablo, -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php