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
