[ACCEPTED]-PHP Check MySQL Last Row-mysql

Accepted answer

Score: 50

You can use mysql_num_rows() prior to your while loop, and then 1 use that value for your condition:

$numResults = mysql_num_rows($result);
$counter = 0
while ($row = mysql_fetch_array($result)) {
    if (++$counter == $numResults) {
        // last row
    } else {
        // not last row
    }
}

Score: 11

$result = mysql_query("SELECT *SOMETHING* ");

$i = 1;
$allRows = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){

    if ($allRows == $i) {
        /* Do Something Here*/
    } else {
        /* Do Another Thing Here*/}
    }
    $i++;
}

but please take in consideration PDO

$db = new PDO('mysql:host=localhost;dbname=testdb', 'username', 'password');
$stmt = $db->query("SELECT * FROM table");
$allRows = $stmt->rowCount();
$i = 1;
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

    if ($allRows == $i) {
        /* Do Something Here*/
    } else {
        /* Do Another Thing Here*/}
    }
    $i++;
}

Score: 3

$allRows = $stmt->rowCount();

Didn't work for me, had to use:

$numResults = $result->num_rows;

Score: 2

Try this:

$result = mysql_query("SELECT colum_name, COUNT(*) AS `count` FROM table");

$i = 0;

while($row = mysql_fetch_assoc($result))
{
    $i++;

    if($i == $row['count'])
    {
        echo 'last row';
    }
    else
    {
        echo 'not last row';
    }
}

Score: 0

Try having a counter inside the while loop 1 and then checking it against mysql_num_rows()

Score: 0

$result = //array from the result of sql query.
$key = 1000; 
$row_count = count($result); 
if($key)
{
    if($key == $row_count-1)  //array start from 0, so we need to subtract.
    {
       echo "Last row";             
    }
    else
    {
       echo "Still rows are there";             
    }
}

Source: stackoverflow.com

Creating your own TinyURL

What is the best way to bind decimal / double / float values with PDO in PHP?

Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?

warning problem: expects parameter 1 to be mysqli_result

Converting date to this format

How to display Unicode data with PHP

PHP errors -> Warning: mysqli_stmt::execute(): Couldn't fetch mysqli_stmt | Warning: mysqli_stmt::close()

Mysql 1 Random Row

configuring database connection in Yii framework

Typical URL lengths for storage calculation purposes (URL-shortener)

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.