If you have auto_increment field set for MySQL table then it is very easy to get details of last row in that table. I have also provided complete php code on how to get details of last n rows in a MySQL table.

First step is, Connect to your database using PHP. Name the file as connect.php

<?php
//change these values accordingly
$host = "localhost";
$username = "root";
$password = "SOMEPWD";
$database = "MY_DATASE";
//Make your connection to database
$con = mysql_connect($host,$username,$password);

//Check your connection
if (!$con) {
die("Could not connect: " . mysql_error());
}

//Select your database
$db_selected = mysql_select_db($database, $con);
//Check your connection
if (!$con) {
die("Could not connect: " . mysql_error());
}
?>

Second step is to run MySQL query and get the last row in the table. Name this file as last_row.php

include('connect.php');
$table = "MY_TABLE";
$lastrow = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT 1");
$get_last_row = mysql_fetch_array($lastrow);
echo $get_last_row['Email_Address'];

In the above code we are initially connecting to the database using the include statement.

SELECT * FROM $table ORDER BY id DESC LIMIT 1

This query will return last row from the table. I have many columns in that table and one of them is named as ‘Email_Address’.

After fetching details of the row we can display it using below code.

$get_last_row = mysql_fetch_array($lastrow);
echo $get_last_row['Email_Address'];

To get last n rows in a MySQL table, All you have to do is change the MySQL query

SELECT * FROM SOMETABLE ORDER BY id DESC LIMIT 3

I have given numeric 3 after LIMIT. That means sql will display last 3 rows in the table. You can change that number according to your needs. In order to display these values in php you need to modify the code and add a while loop.

$lastrow = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT 3");;
while($get_last_row = mysql_fetch_array($lastrow))
{
echo $get_last_row['Email_Address']."<p>";
}

Incoming search terms:

• get last row from mysql table (1)
• how to get the last row in database PHP (1)
• last 5 history coming from php table mysql database (1)
• php get last field in database table (1)
• php get last row (1)
• php sql last (1)
• restjpf (1)
• select last row from mysql (1)