Re[2]: Empty query result

["Pablo M. Rivas" <pmrivas01@xxxxxxxxxxxx>]

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