$sql = "SELECT this FROM table WHRE this=this ORDER BY userid DESC LIMIT 1";
the key is the ORDER DESC part of the query
Query to get last row was inserted in a database table
Sent To Friend
CLick this button if you want to send this page to a friend.
CLick this button if you want to send this page to a friend.
Query to get last row was inserted in a database table
Post Description: query to get last row was inserted in a database table MYSQL
Post Tags:
This Post Has Been Viewed 305 Times Since Tue Oct 14, 2008 11:56 pm Author hostman with 0 replies
Post Description: query to get last row was inserted in a database table MYSQL
Post Tags:
This Post Has Been Viewed 305 Times Since Tue Oct 14, 2008 11:56 pm Author hostman with 0 replies
Query to get last row was inserted in a database table
Advertise On This Page
one of the most useful queries in mysql with php is when you wan tto query a row in your mysql database which is the last row or the last entry you just entered in a database table. well this is how you do it:
$sql = "SELECT this FROM table WHRE this=this ORDER BY userid DESC LIMIT 1";
the key is the ORDER DESC part of the query
$sql = "SELECT this FROM table WHRE this=this ORDER BY userid DESC LIMIT 1";
the key is the ORDER DESC part of the query
Leave Your Comments
Share
Share this page by putting this URL in your comments to other websites like myspace, Facebook, Twitter friendster, Hi5, Groups, Boards, Forum or others. Just Copy and Paste this Code
URL:
To embed this topic, just copy the code from the "Embed" box. Once you've copied the code, just paste it into your website or blog to embed it.
Embed:
BBCODE is use on forums. You can put this code on all your BBCODE enabled forums like PhpBB, vBulletin® and others. Just Copy and Paste this code on your Posts and Replies on your forums
BBCODE:
Webmasters - Exchange Links With Us. Add related websites to this topic
Links Related to : Query to get last row was inserted in a database table
Comments and replies About Query to get last row was inserted in a database table
(0) Comments