[RESOLVED] get last row of result MySQL

[Arc]

Hey guys I am making a wrapper class for MySQL functions and I want to be able to return the last row from a query.

here is the function in my class

function getLastRow(){
		$this->lastRow = mysql_data_seek($this->result,$this->numRows-1)
		return $this->lastRow;
	}//end getLastRow

I am using mysql_data_seek and pointing it to the last row, but it is not returning anything.

If you need the entire code let me know.

Thanks for the help!!

[bpat1434]

YOu need to get it into an array.....

function getLastRow(){
    if(@mysql_result($this->result, $this->numRows-1))
    {
        $lastRow = mysql_fetch_array($this->result);
    }
    else
    {
        // Throw an error!
    }
    return $lastRow;
}

I also question why lastRow is "global" to the class, yet you return it.... if it's global, and within the class, you don't need to return it. But hey, that's just my young eyes catching code....

[Arc]

Thanks for the response, but your code is only getting the first row of the result....

lastRow is global for now, I might change it, I am not done with this class and I may call it into other functions, haven't decided yet. It is returned, because that is what the function returns...not sure what you mean by that.

But just to clear things up I am posting my entire class and how I am using it..

Everything in the class works fine except the getLastRow() and getAnyRow ()functions.

class dbConTran{ 

var $con; 
var $numRows; 
var $result; 
var $resultArray; 
var $firstRow = array(); 
var $lastRow = array(); 
var $anyRow = array();


 // Open Database connection --------- 
 function dbOpen($name,$host,$user,$password){ 
    $this->con = @mysql_connect($host, $user, $password)or die ("Error Connecting to Database!"); 
    @mysql_select_db($name, $this->con) or die ("Error Selecting Database!"); 
 }//end dbOpen 

 // Close Database Connection -------- 
 function dbClose(){ 
    @mysql_close($this->con); 
 }//end dbClose 

 // INSERT, UPDATE or DELETE from Database -------- 
 function dbIUD($sql){ 
     $this->result = @mysql_query($sql); 
    if(!$this->result){ 
        return false; 
    }else{ 
        return true; 
    }//end if         
 }//end dbIUD 

  // SELECT FROM Database -------- 
 function dbSelect($sql){ 
 	$this->result = @mysql_query($sql); 
    $this->numRows = @mysql_num_rows($this->result); 
    if(!$this->result){ 
        return false; 
    }else{ 
        return true; 
    }//end if         
 }//end dbSelect 

 // Get first row of dbSelect -------- 
 function getFirstRow(){ 
     $this->firstRow = mysql_fetch_array($this->result); 
    return $this->firstRow; 
}//end getFirstRow 

// Get last row of dbSelect -------- 
 function getLastRow(){ 
    $this->lastRow = @mysql_data_seek($this->result,$this->numRows-1);
    return $this->lastRow; 
}//end getLastRow 

// Get any row of dbSelect -------- 
 function getAnyRow($rowNum){ 
 	if($rowNum > $this->numRows){
		return false;
	}else{
    	$this->anyRow = @mysql_data_seek($this->result,$rowNum); 
    	return $this->anyRow; 
	}//end if
}//end getLastRow 

 // Get number of rows from dbSelect -------- 
 function getNumRows(){ 
    return $this->numRows; 
}//end getNumRows 


}// End Of Database Class ------------------------------- 

And here is how I'm using it

$db = new dbConTran();

$sql ="SELECT * FROM tblBooks";

$Database = "name";
$Hostname = "localhost";
$Username = "user";
$Password = "pass";

$db->dbOpen($Database,$Hostname,$Username,$Password);

$db->dbSelect($sql);

echo $db->getNumRows()."<br>";


$firstRow = $db->getFirstRow();
echo $firstRow['AuthorName']."<br>";

$lastRow = $db->getLastRow();
echo $lastRow['AuthorName']."<br>";

$db->dbClose();

Thanks for the help!

[bpat1434]

mysql_data_seek just moves teh pointer, doesn't actually return anything... so assigning it's value to $this->lastRow would make $this->lastRow either TRUE or FALSE (boolean).

// Get last row of dbSelect --------
     function getLastRow(){
        mysql_data_seek($this->result, $this->numRows-1);
        $this->lastRow = mysql_fetch_array($this->result);  // YOU NEED THIS
        return $this->lastRow;
    }//end getLastRow

[Arc]

That did the trick! Thanks a lot! I thought it returned an array, but your explination realy helped.

changed the code to this

function getLastRow(){ 
       @mysql_data_seek($this->result,$this->numRows-1);
		$this->lastRow = mysql_fetch_array($this->result); 
        return $this->lastRow; 
    }//end getLastRow 

🙂

[Arc]

Ohh and sorry bpat1434, after re-reading your explanation it makes more sense now. I didn't get it at first.

[bpat1434]

Explanation of what? The class-global or the initial post about there being no fetched array?

[Arc]

No, the global was on purpose as I said. It may be used elsewhere in the class, not finished with it yet, if It is not needed later I will keep it local to the function.